| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find values in table and return correpsonding data in array
I'm not sure if you can do this in an array function or if it takes programming, but I am trying to search a database for multiple entries and display corresponding data separately in a new table. For example,
1 Red 2 Blue 1 Green 3 Yellow I would like to create a new table that pulls out the data in column 2 if column 1 equals "1", like this... Red Green Does anyone know if I can do this? I've tried VLOOKUP, INDEX & MATCH, and OFFSET & MATCH. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find values in table and return row/column name | Excel Worksheet Functions | |||
| Find Max in array- return corresponding cell | Excel Worksheet Functions | |||
| Find data in table with to set of constant values | Excel Worksheet Functions | |||
| Use array to return array of values | Excel Worksheet Functions | |||
| VBA Syntax for VLOOKUP to return array of return values | Excel Programming | |||
Threaded Mode
