IFERROR function « Chandoo.org - Learn Excel & Charting Online

Chandoo.org - Learn Excel & Charting Online - Forums » Ask an Excel Question

IFERROR function

(10 posts) (5 voices)

Started 1 year ago by lee1767
Latest reply from NARAYANK991

Tags:

No tags yet.

lee1767

Member
Joined: Apr '10
Posts: 13

Dear sifu,

I'm using "IFERROR" function in Excel 2010 and save as .xlsx file.
Example : =IFERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE)," ")

When I open with excel 2007 and 2003, the cell with this formula will return as #NAME.
Is "IFERROR" function not available in excel 2007 & 2003?

Thank you.

Posted 1 year ago #
Faseeh

Excel Ninja
Joined: Jan '12
Posts: 1,591

Hi lee1767

Iferror() is available in 2007 so should not give Name Error. However It was not available in Excel 2003.

Regards,
Faseeh

Posted 1 year ago #
SirJB7

Excel Ninja
Joined: Dec '11
Posts: 4,538

Hi, lee1767!
Consider replacing 2007/2010 IFERROR formula construction by this all versions compatible one:
=IF(ISERROR(condition)," ",value)
Regards!

Posted 1 year ago #
lee1767

Member
Joined: Apr '10
Posts: 13

Hi, SirJB7

I was trying the formula as you suggested, but I just can't get it right.

=IF(ISERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE)," ",VALUE)

Is this formula correct?

Please help....

Thank you.

Posted 1 year ago #
NARAYANK991

Excel Ninja
Joined: Oct '11
Posts: 4,090

Hi ,

When SirJB7 wrote :

=IF(ISERROR(condition)," ",value)

he meant that if the condition test does not return an error , you need to repeat it. So , according to your example , the formula will be :

=IF(ISERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE)," ",VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE))

Narayan

Posted 1 year ago #
SirJB7

Excel Ninja
Joined: Dec '11
Posts: 4,538

Hi, lee1767!
Sorry for the assumptions, I should have stated it more clearly as NARAYANK991 did.
Hope it works for you.
Regards!

@NARAYANK991
Hi!
Thanks for the backup, been on the street whole day.
Regards!

Posted 1 year ago #
NARAYANK991

Excel Ninja
Joined: Oct '11
Posts: 4,090

Hi SirJB7 ,

Hi ! One for all , all for one !

Narayan

P.S. Hope you have it easy today.

Posted 1 year ago #
lee1767

Member
Joined: Apr '10
Posts: 13

Dear Sifu,

I had tried the formula as mentioned by NARAYANK991.
When I key in the formula and enter, Excel prompt up the message as below :

"You've entered too many arguments for this function."
"To get help with this function, click OK to close this message. Then click the Insert Function button located to the left of the equal sign in your formula."

Please help......

Posted 1 year ago #
MBegg

Member
Joined: Mar '12
Posts: 15

1 bracket missing to close the ISERROR() function. Should be:

=IF(ISERROR(VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE))," ",VLOOKUP(H1,Sheet1!$C$1:$E$100,2,FALSE))

Posted 1 year ago #
NARAYANK991

Excel Ninja
Joined: Oct '11
Posts: 4,090

Hi MBegg ,

You are right ; thanks for catching my mistake.

Narayan

Posted 1 year ago #