How do I get multiple Vlookup responses?

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
 
K

Ken Wright

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

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