Nested VLOOKUP in IF statement

J

jason.jaesung

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.
 
H

Heera

remove the "=" before the function vlookup.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nested VLOOKUP in IF statement 2
Nested If Function to be converted into a user-defined customfunction 1
Improving Nested Formula Calculation Efficiency 2
Nested If / And Statement with Conditional Formatting. 2
Nested IF statement 4
Start Do/Loop within conditional statement 4
Combining IF Statement and Vlookup 0
Excel IF statement with vlookup 2

Top