| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to find specific a value across a row using IF(AND
What should it return if none of the cells contain your criteria? In this
formula it will return blank in that case. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC","") HTH, Paul -- "SCrowley" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to find specific a value across a row using IF(AND
WORKS BEAUTIFULLY! Thank you.
-- Thank you, scrowley(AT)littleonline.com "PCLIVE" wrote: What should it return if none of the cells contain your criteria? In this formula it will return blank in that case. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC","") HTH, Paul -- "SCrowley" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to find specific a value across a row using IF(AND
Can I look for more than one string?
=IF(COUNTIF(AW2:BK2,"DC Office","Charlotte Office","Dallas Office"),"Washington DC","Charlotte, NC","Dallas, TX","") -- Thank you, scrowley(AT)littleonline.com "PCLIVE" wrote: What should it return if none of the cells contain your criteria? In this formula it will return blank in that case. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC","") HTH, Paul -- "SCrowley" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to find specific a value across a row using IF(AND
Thank you so much. Is it possible to look for more than one string?
=IF(COUNTIF(AW2:BK2,"DC Office","Charlotte Office","Dallas Office"),"Washington DC","Charlotte, NC","Dallas, TX","") -- Thank you, scrowley(AT)littleonline.com "PCLIVE" wrote: What should it return if none of the cells contain your criteria? In this formula it will return blank in that case. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC","") HTH, Paul -- "SCrowley" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need to find specific a value across a row using IF(AND
There is probably another way to do it, but you could use a nested IF
statement here. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC",IF(COUNTIF(AW2:BK2,"Charlotte Office"),"Charoltte, NC",IF(COUNTIF(AW2:BK2,"Dallas Office"),"Dallas, TX",""))) HTH, Paul -- "SCrowley" wrote in message ... Thank you so much. Is it possible to look for more than one string? =IF(COUNTIF(AW2:BK2,"DC Office","Charlotte Office","Dallas Office"),"Washington DC","Charlotte, NC","Dallas, TX","") -- Thank you, scrowley(AT)littleonline.com "PCLIVE" wrote: What should it return if none of the cells contain your criteria? In this formula it will return blank in that case. =IF(COUNTIF(AW2:BK2,"DC Office"),"Washington DC","") HTH, Paul -- "SCrowley" wrote in message ... 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 |
| Reply |
| 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) | |||
Linear Mode
