JG wrote:
This works

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

Thanks JG

JG wrote:
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.



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

"JG" wrote:

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



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

Ken Johnson