Hi All,
This is my 1st post & Thank-You very much for the approval.
I would like to solve this lookup with auto marking "RIGHT" by using conditional formatting. i am not sure what is the best functions to achieve this either VLOOKUP/INDEX & MATCH with IF to the cell E7:E9.
CELL VALUE: F1
LOOKUP VALUE: F1 =IF($F$1>=100, "Success", IF($F$1>=50, "Mid", IF($F$1>0, "Poor")))
TABLE ARRAY: E3:E59
MARKED CELL: F3/E4/E5
RATING.JPG
What i want is RIGHT will marked accordingly to the cell F3/F4/F5 whenever the LOOKUP VALUE changes.
Your help is highly appreciated.
Thank-You very much
Bookmarks