| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
lookup 2 columns, return value from third
I have two tables of pretty much the same format. Column A shows a name that
may or may not be repeated a few times, while column B shows one of four values (say, 1, 2, 3, 4). I need a formula that will return the result of the third column, if it matches Column A and Column B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on 2 columns; return 1 value | Excel Worksheet Functions | |||
| V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
| lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
| Lookup 3 columns and return a result from another column | Excel Discussion (Misc queries) | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
Threaded Mode
