Apr 23 2021 09:02 AM - edited Apr 23 2021 09:12 AM
Hello all - Hoping all safe!
I am trying to use a lookup formula to check if a text string is present in a column cell, and if so, it returns a value TRUE in a different column but the same row.
for example: checking for a string "Need Material" in cell B3, should return a value TRUE in a cell K3 and so on for all other rows respectively.
Cell source (ex: B3) may contain multiple strings including the one for which is search is to be made: Example:
B3 == Missing Router, Need Material, Labor Shortage
C3 == Need Material, Labor Shortage
D3 == Labor Shortage
etc etc. and in any combination of the possible values.
=LOOKUP(2^15,SEARCH({"Need Material},$B3),{"TRUE"})
Somehow the formula is returning a FALSE value even if B3 has the string "Need Material" is existing. Any advise?
Thank you!
Apr 23 2021 11:18 AM
Apr 23 2021 12:25 PM