Hello,
I just want to ask how to do this in excel or rather what formula I will use? Please see image below;
In cell A3, if I put a number equal to any of the numbers under E column then it will show the word SUBMITTED in cell B3.
If the number I put in cell A3 is equal to any of the numbers under F column then it will show the word PENDING in cell B3.
If the number I put in cell A3 is equal to any of the numbers under G column then it will show the word FINISHED in cell B3.
If the number I put in cell A3 is not equal to any of the numbers under column E, F and G, then B3 will remain blank.
Thanks in advance.