vlookup function

J

jain_sanju

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.
 
F

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
 
Top