LinkBack URL
About LinkBacks
Hello,
I am looking for either this existing formula or a better one for a =IFS(SEARCH
I want the IF to return Y when the condition is true, otherwise, leave the cell blank. Capture.JPG
Hello,
I am looking for either this existing formula or a better one for a =IFS(SEARCH
I want the IF to return Y when the condition is true, otherwise, leave the cell blank. Capture.JPG
Try this...
Enter formula in B2 and copy down
Formula:
Please Login or Register to view this content.
v A B 1 Catalogue 2 Food generic recipe Y 3 place of the rice Y 4 only the strong Y 5 wheathouse place
The better way would be to create a lookup table:
In B2
Formula:Please Login or Register to view this content.
v A B C 1 Catalogue Result Lookup values 2 Food generic recipe Y generic 3 place of the rice Y rice 4 only the strong Y strong 5 wheathouse place
Last edited by AlKey; 03-27-2019 at 10:09 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
@ AlKey , the formula above worked like a charm. And I can expand on it down the road with more conditions vs the IFS that I was thinking about using. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks