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 the`Formulas`

ribbon? What do you see? – Excellll Jan 31 '14 at 14:55