Nested VLOOKUP in IF statement
Lose the quotes
=IF(H5=$C$2,VLOOKUP(H4,$B$5:$C$11,2,FALSE),0)
Mike
" wrote:
Hi all,
This is my very simple nested IF statement.
=IF(H5=$C$2,"=VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0)
Basically, I want the VLOOPKUP function to "work" when the value is
false,
instead, it prints the actual formula in the cell as a value.
Any clues here?
Thanks in advance.
|