HELP!!!!!!!

[oji656]

I need some help on how to do a vlookup sort of function to bring data across to another worksheet. The data is arranged in the format below.

15209 C02283 STOP & SHOP BM-32693-7 12.00 7,576.69 0.00 6,670.67
15210 C02283 STOP & SHOP BM-32694 12.00 1,236.31 0.00 2,149.44
15211 C02283 STOP & SHOP BM-32696 12.00 7,873.23 0.00 8,264.19

I want to do a lookup on the C02283, and be able to pull the info on the right hand side into the worksheet. I can bring the first line of the information in with the vlookup, but how do I get the information underneath it with the same C02283 to come in also. Is there another function that will do this for me????

Aaaaahhhh!!!

Help

 

[Oaktree]

What will you be using the data for? Would filtering it in place suffice? (data --> filter --> autofilter)