View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jason.jaesung@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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.