How do I get multiple Vlookup responses?
 

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

How do I get multiple Vlookup responses?
 

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

Regards
Ken.....................


"Erik Feenstra" <Erik wrote in message
...
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