According to this and my own testing, using VLOOKUP can be compared to a specific value inside of IF.
E. g.: = IF(VLOOKUP(...) = 20, [then value], [else value])
works.
But if I compare the result of the VLOOKUP to the value in a certain cell, it does not return a value:
IF(VLOOKUP(...) = E$1, [then value], [else value])
It looks like IF does not evaluate the comparison, but only VLOOKUP. Adding brackets does not help:
IF((VLOOKUP(...) = E$1), [then value], [else value])
doesn't work either.
In the first example, I compare VLOOKUP to 20. In the second example, I want to compare it to the value in E1. (E1 has a static value, but I want to use the formula in a matrix where each field compares the result of VLOOKUP to the column heading and returns a different value if they match or not.)
How could I get this to work?
Edit: I confused the values that I compare the result of VLOOKUP to. The formula does work; you just have to use the right cells.
Evaluate Formula
on theFormulas
ribbon? What do you see?