VLOOKUP

  • Thread starter Thread starter Randy
  • Start date Start date
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.
 
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
 
Back
Top