How do I get multiple Vlookup responses?

  • Thread starter Thread starter Erik Feenstra
  • Start date Start date
E

Erik Feenstra

I want to list all values in column 3 corresponding to a range of values
(e.g. between 1000 and 2000) in column 1. It appears to me that Vlookup can
only give one response.

Thanks a lot!

Erik
 
So just use Autofilter on Col 1 with a custom filter.

Regards
Ken.....................
 
Back
Top