Hi,

I have a huge file with 10,000 records with like +25 rows and some of the
jobs are repeated several times. Using the Job as the reference in vlookup i
am trying to populate the data in a different worksheet, but vlookup just
takes the list row information of a perticular job but i want it to take the
data from all the lines for that job. EX:
Jim Dell
Jeff HP
Carl Compaq
Jim Toshiba
Carl Sony
Jim Lenovo
Jeff IBM

I want the data to populated in this way:
Jim dell
Jim toshiba
Jim lenovo
but its populating like:

Jim dell
Jim dell
Jim dell

Can someone help me on this? i found some formulas but those are for
relatively small data, but how wld i do it with such a huge data?