Sep 10 2021 02:03 PM
on one tab I have a list of names
on a second tab I have a list of the names and next to them in another cell an A, B, or C ranking
I want the first tab to match the name in the second tab to the ranking next to it and color the cell based on the latter ranking.
This works if the names are numbers, but once it is actual text names it doesn't work properly. I am making this in a google sheets doc as I do not have 365 to do filter formulas.
Using this coding:
=VLOOKUP(E2,indirect("Names!B2:C115"),2,TRUE) = "A"
In the pictures the rankings are the same. A(green) for 1-29 B(Yellow) 30-70 C(Red)71-114. All names are from a name generator and not actual names. Just trying to make the function work properly.
Thank you,
Dan
Sep 10 2021 06:56 PM
Sep 11 2021 02:25 AM
SolutionHere is working sample
Conditional formatting rule formulae as
=INDEX($H$2:$H$5,MATCH(E2,$G$2:$G$5,0)) = "A"
Sep 13 2021 02:52 PM
Sep 14 2021 08:29 AM
@Danimal513 , you are welcome
Sep 11 2021 02:25 AM
SolutionHere is working sample
Conditional formatting rule formulae as
=INDEX($H$2:$H$5,MATCH(E2,$G$2:$G$5,0)) = "A"