Forum Discussion
Solved
One cell has specific word that triggers another cell to show a word
I have a master list of all the projects we are working on at work, and I would like one cell to change based on my input in another cell. I manually change the “Primary Status” in Column P using dat...
In O5:
If you have Microsoft 365 or Office 2021:
=XLOOKUP(P5,ProjectCode,StageCode,"-")
If you have an older version:
=IFERROR(INDEX(StageCode,MATCH(P5,ProjectCode,0)),"-")
Fill down.
=INDEX(StageCode,MATCH(TRUE,ISNUMBER(SEARCH(P5,ProjectCode)),0))
I switched the search criteria to " P5,ProjectCode " and it works in my spreadsheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Ah, yes, this also works out wonderfully! I appreciate the fast response and solution to my convoluted formula. I slightly liked the other answer a tad more, just for the shorter formula and that a blank will return a “-”, but your formula worked perfectly for what I was asking as well. Thanks again. You rock!