VLOOKUP

R

Randy

in the range that contains the lookup value, there are
multiple or duplicate entries, is there a function or
formula that gives all possible finds rather than the
first one that excel finds? thanks in advance.
 
A

Alan Beban

Randy said:
in the range that contains the lookup value, there are
multiple or duplicate entries, is there a function or
formula that gives all possible finds rather than the
first one that excel finds? thanks in advance.
Click to expand...
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook, the
VLookups function does.

Alan Beban
 
Top