What would be the purpose of having an absolute cell reference instead of a column number in a VLOOKUP formula?
Example: =VLOOKUP(A9,$AC$9:$CR$20,25,FALSE)
vs.
=VLOOKUP(A9,$AC$9:$CR$20,$CR$8, FALSE)
where $CR$8 = 68
and column CR has 1 in CR9, 2 in CR10, 3 in CR11
The conditional format...