Lookup help

[Barky]

Ifyou have a classification of data of ABC and it appears in a list
times with different information when I want to do a vlookup to pul
all the relevant data for ABC into a new sheet, then the lookup wil
just pull back the data for the first one found continuously and no
move onto the second and third listing of ABC. So how do you get th
lookup to move on through the sheet to pull back all of the relevan
data?

i.e.

ABC 12 12 12
ABC 13 12 13
ABC 14 12 14

The present vlookup will just bring back
ABC 12 12 12
And not move onto the other returns for this classification.

Thank

 

[Domenic]

On your new sheet, enter the following formula and copy across an
down:

=INDEX(Sheet1!A:A,SMALL(IF(Sheet1!$A$1:$A$100="ABC",ROW(Sheet1!$A$1:$A$100)),ROW(1:1)-ROW(A$1)+1))

...entered using CONTROL+SHIFT+ENTER.

Hope this helps!