IF troubles

[JG]

This is my IF function I'm trying to get to work.

=IF(L11=0,0,"=VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2,FALSE)")

This works if L11 = 0 but if it does not = 0 it fails. If I use this
VLOOKUP without outside of the IF function it also work. Is there
something wrong with my syntax?

Thanks for the help JG

 

[Guest]

=IF(L11=0,0,VLOOKUP(L11,Sheet1!$CA$1724:$CC$1735,2,FALSE))

 

[Bill Foley]

Get rid of the second equal sign and try it.

 

[Bill Foley]

Oops, AND quotes. The "False" item doesn't need quotes if it is a function.

 

[JG]

I thought that myself and even tried it again after the suggestion.
When L11 is a zero it works and when it is a name (john) I get the
formula in the cell.

 

[JG]

This works

=IF(L3=0,0,VLOOKUP(L3,Sheet1!$CA$1724:$CC$1735,2,FALSE))

Thanks JG

 

[Ken Johnson]

This works

=IF(L3=0,0,VLOOKUP(L3,Sheet1!$CA$1724:$CC$1735,2,FALSE))

Thanks JG

Maybe L11's format was Text, causing the formula to be shown rather
than its result.
Try reformatting L11 to General.

Ken Johnson