Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Troubles with asigning x values and values to a chart	[email protected]	Excel Discussion (Misc queries)	0	July 31st 06 04:15 PM
AutoWordSelect in Combo Box Troubles	merritts	Excel Discussion (Misc queries)	0	July 27th 06 07:56 PM
date sorting troubles	Nevin	Setting up and Configuration of Excel	5	June 14th 06 10:13 PM
List Box Troubles	LostNFound	Excel Discussion (Misc queries)	1	January 20th 06 06:46 PM
Troubles with the OFFSET function	ghostrider	Excel Worksheet Functions	6	June 1st 05 05:20 PM

All times are GMT +1. The time now is 05:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us