vlookup function

[Guest]

vlookup gives the result / value as soon as soon as it finds the first value.
How can i have rest values in excel satisfying same conditions , 2nd , 3rd
etc.

 

[Frank Kabel]

Hi
try the following kin of array function:

=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=lookup_value,ROW
($A$1:$A$100)),ROW(1:1)))
and copy down as far as needed