IF troubles
 

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

IF troubles
 

=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

IF troubles
 

Get rid of the second equal sign and try it.

--
Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com
"JG" wrote in message
oups.com...
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

IF troubles
 

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

--
Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com
"Bill Foley" <pttincatitexasdotnet wrote in message
...
Get rid of the second equal sign and try it.

--
Bill Foley
Microsoft PowerPoint MVP
Microsoft Office Specialist Master Instructor
www.pttinc.com
"JG" wrote in message
oups.com...
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

IF troubles
 

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

IF troubles
 

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

IF troubles
 

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