Posted to microsoft.public.excel.misc

Wanna Learn Wanna Learn is offline

external usenet poster

Posts: 318

IF iserror does not work

Hello I'm reposting a question a little different. Here we go this is my
simple formula
=VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this
works now I want to add if is error equal 0
=if(Iserror(VLOOKUP(A1,Sheet1!$A$1:$D$200,4,
IF(Sheet1!B1="Fax",4,FALSE)),0,VLOOKUP(A1,Sheet1!$ A$1:$D$200,4,
IF(Sheet1!B1="Fax",4,FALSE)) it does not work.... thanks in advance

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
Iserror does not work for missing sheets in linked file	[email protected]	Links and Linking in Excel	1	June 13th 07 06:31 PM
use of ISERROR	NathanG	Excel Worksheet Functions	8	January 24th 07 06:31 PM
Iserror	kelljeff	Excel Discussion (Misc queries)	2	May 17th 06 03:02 PM
Iserror & VBA	Ken G.	Excel Discussion (Misc queries)	1	February 28th 06 11:37 PM
ISERROR Functin to Much Work!	ExcelMonkey	Excel Worksheet Functions	2	November 12th 04 08:47 PM

All times are GMT +1. The time now is 10:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us