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.
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.
- The xlookup function worked wonders, thank you so much! I appreciate the quick reply and the clear instruction, you rock.
