Nested VLOOKUP in IF statement

[jason.jaesung]

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

Hi all,

Above is my simple nested vlookup statement.
The problem is, it may be too simple.
Basically I'd like for this vlookup statement to run when the
condition is met.

When the condition is true, the result is "=VLOOKUP(H4,$B$5:$C
$11,2,FALSE)"
printed in the cell as a value instead of returning the formula
result.

I've tried the following without success...

=IF(H5=$C$2,"VLOOKUP(H4,$B$5:$C$11,2,FALSE)",0) <--- without the =
=IF(H5=$C$2,=VLOOKUP(H4,$B$5:$C$11,2,FALSE),0) <--- without the
"quotes"

Is there something I'm doing wrong?

Cheers

 

[minli]

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

 

[jason.jaesung]

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












- Show quoted text -

Thank you.
Works a charm