John Darby
asked on
Excel lookup and display text based on number in adjacent cell
I have a calculated value in cell E2,
In cell F2, I want to do the following:
1. display the same color displayed in E2
2. if value displaying in E2 < 20, display ADVISORY in F2
3. if value displaying in E2 > 19, display RFC in F2
4. if value displaying in E2 > 39, display ESCALATE in F2
Thank you for your help!
JohnD
test.xlsm
In cell F2, I want to do the following:
1. display the same color displayed in E2
2. if value displaying in E2 < 20, display ADVISORY in F2
3. if value displaying in E2 > 19, display RFC in F2
4. if value displaying in E2 > 39, display ESCALATE in F2
Thank you for your help!
JohnD
test.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're Welcome John! Glad I was able to help :)
ASKER