Nested VLOOKUP in IF statement
 

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.

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.

Nested VLOOKUP in IF statement
 

remove the "=" before the function vlookup.

When there is a function inside the other function you should not use
= sing.

Nested VLOOKUP in IF statement
 

try this

=IF(H5=$C$2,0,VLOOKUP(H4,$B$5:$C$11,2,FALSE))

Anything between quotes is treated as a text string, so it prints the
formula instead of evaluating it. Also the VLookup was in the True argument
of the IF statement.

Mike F
wrote in message
...
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.