vlookup with multiple

[Jesse]

I was looking for help with one vlookup question. How
can I solve the problem of having the "lookup_value" show
up in the "table_array" more than once? It will always
look to the first value. Thanks for the help.

 

[Frank Kabel]

Hi
you could use the following type of array formula (committed with
cTRL+sHIFT+ENTER) to return all matches:
=INDEX($B$1:$B$100,SMALL(IF($A$1:$A$100=lookup_value,ROW($A$1:$A$100)),
ROW(1:1)))
and copy this down as far as needed

 

[Jesse]

Thanks. Not sure I follow but that's probably my fault.
Is there any way to keep the array table static and
adjust the vlookup formula? I have IF functions included
with my vlookup as it is but I keep referencing (looking
up) the first value. I really do appreciate the help and
am sorry that I'm not able to implement what you
suggested. Cheers.

 

[Frank Kabel]

Hi
ost your VLOOKUP formula. I just replaced VLOOKUP with an INDEX/MATCH
combination

 

[Alan Beban]

I was looking for help with one vlookup question. How
can I solve the problem of having the "lookup_value" show
up in the "table_array" more than once? It will always
look to the first value. Thanks for the help.

If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=
VLookups(lookup_value,table_array,n)

array entered into a verticle range of cells sufficient to accommodate
the output will return the matching values from the nth column of the
table array.

Alan Beban