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