| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple responses for a column | Excel Discussion (Misc queries) | |||
| Help with questionnaire responses | Excel Worksheet Functions | |||
| no responses... | Excel Discussion (Misc queries) | |||
| counting responses - please help | Excel Worksheet Functions | |||
| adding up yes, no, n/a responses | Excel Discussion (Misc queries) | |||
Hybrid Mode
