Hi Excel Forum!
I am working with a formula that works perfectly! Basically, the formula:
=IF(ISERROR(FIND("TX", AllTracking!AA16)) = FALSE, AllTracking!AB16, "")
displays the results of AB16 if AA16 match "TX". That works great but now I need to add some layers. I need to add not only "TX", but also "HV", "CSSRS", "GAD" and "SRA". How can I modify my formula to include searching for these items. Using OR maybe??
Additionally, the cells to look for is actually AA16:AJ16.
I have also tried =IF(AA17="HV",DA17,IF(AA17="TX",DE17, IF(AA17="SRA",DL17,IF(AA17="GAD",DS17,IF(AA17="PHQ",DO17, IF(AA17="CSSRS",DW17,"")))))) but to no avail....
Any help will be appreciated!
Thanks!
Bookmarks