| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup multiple values
Assuming the following table of categories and values:
A B 1 cat1 val1 2 cat2 val2 3 cat3 val3 4 cat1 val4 5 cat2 val5 I need to lookup multiple values for the same category: Ex: if in cell C1 i lookup cat1 it returns val1, then if in cell D1 i lookup cat1 it returns val4. Thanks in advance for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| LOOKUP MULTIPLE VALUES | Excel Discussion (Misc queries) | |||
| Lookup on multiple values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Lookup multiple values on multiple sheets | Excel Programming | |||
Threaded Mode
