Hi,

Try this array formula (Ctrl+Shift+Enter)

=IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2))

$A$10 contains Jim. Now copy the formula down

A1:A7 would contain names. B2:B7 would contain company names (Dell, HP
etc.)

Hope this helps

Regards,

Ashish Mathur

"nick" wrote:

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?