How do I get multiple Vlookup responses?

[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

 

[Ken Wright]

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

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