| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup based on 2 criteria
Column A Column B Column AU
Apples text1 22 Apples text2 3 Apples text24 1 Bannanas text11 29 Cell AW2 = "Apples" Cell AY2 = "1" I would like a formula in Cell AX2 to return "text24" what is that formula? thanks I tried it myself based on numerous examples on this discussion group, but just couldn't do it, many thanks... SteveC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup based on two criteria. . . | Excel Discussion (Misc queries) | |||
| Criteria Lookup based on Dates | Excel Discussion (Misc queries) | |||
| Lookup based on 2 criteria | Excel Worksheet Functions | |||
| Lookup based on two criteria in 1 row | Excel Discussion (Misc queries) | |||
| LOOKUP value based on 2 criteria | Excel Worksheet Functions | |||
Threaded Mode
