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