| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to find specific a value across a row using IF(AND
I have searched through the archives and threads and thought I found the
solution but to no success. I want to find "DC Office" across cells AW2:BK2, if one of those cells contains that text I need it to populate BL2 with "Washington, DC" Here is the formula I've tried: =IF(AW2="DC Office","Washington, DC",IF(AND(AX1="DC Office"),"Washington, DC",IF(AND(AY1="DC Office"),"Washington, DC",IF(AND(AZ1="DC Office"),"Washington, DC",)) Any help is greatly appreciated. Thank you. -- Thank you, scrowley(AT)littleonline.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find specific value in a string | Excel Discussion (Misc queries) | |||
| Find a specific posting | New Users to Excel | |||
| find value in specific row | Excel Discussion (Misc queries) | |||
| MIN to find specific lowest value | Excel Worksheet Functions | |||
| How Do I Find A Specific Worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
