Need to search for 3 separate items

[jphilipson]

Hey Guys,

I need to search row H-5 for WAC, also search M-5 for RTC or PHP, if they find both items I need them to return the value of E-5. Then I need to be able to copy the formula all the way down to line 66. I hope this makes sense.

[Bernie Deitrick]

It depends on what you mean by search. In whatever column you are using, in row 5:


If you mean those values exactly:

=IF(AND(H5="WAC",OR(M5="RTC",M5="PHP")),E5,"")

If you mean they have strings that may contain those substrings:

=IF(AND(NOT(ISERROR(FIND("WAC",H5))),OR(NOT(ISERROR(FIND("RTC",M5))),NOT(ISERROR(FIND("PHP",M5))))),E5,"")