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