How to search with multiple criteria

[SIYAM]

untitled.JPG


I have to create a report

In the above excel sample In "ARCHITECTURE" column the whenever "xxx" or "bba" is found the value should be updated as "used" or else "not used"

Any ideas how to do this

I already tried

=IF(ISNUMBER(SEARCH("xxx",E2:Q2,1)),"Y",IF(ISNUMBER(SEARCH("bba",E2:Q2,1)),"Y","N"))

and

Using match funtion


Please help...its urgent

[Haseeb Avarakkan]

Hello Siyam, try

Please Login or Register  to view this content.

[SIYAM]

Thankyou haseeb