Excel ISERROR can't figure it?

[Chapster5]

Hi guys,

Having trouble getting ISERROR to replace any #N/A with 0 value in the column. Here's what I currently have but it doesn't seem to work?

=ISERROR(VLOOKUP($S$2,Q2:R2,2,FALSE),"0",(VLOOKUP($S$2,Q2:R2,2,FALSE)))

Apparently I have too many arguments in the formula?

 

[yourcodenameisnick]

Take out the 2nd vlookup.

The 0 is only there if there's an error.

 

[Chapster5]

=ISERROR(VLOOKUP($S$2,Q2:R2,2,FALSE),"0"))

Tried that and it's still saying still too many arguments?

 

[AK]

=ISERROR(VLOOKUP($S$2,Q2:R2,2,FALSE),0)

Tried that and it's still saying still too many arguments?

This should work.

 

[Reev]

If you're using something newer than Excel 2003 then I'd just use if the IFERROR function, i.e.

=IFERROR(VLOOKUP($S$2,Q2:R2,2,FALSE),0)



If you want to still use ISERROR, then I think you need to use an IF function beforehand, like so:

=IF(ISERROR(VLOOKUP($S$2,Q2:R2,2,FALSE),0,(VLOOKUP( $S$2,Q2:R2,2,FALSE))))


I've only been using Excel for less than 3 months though so that may well all be lies


Edit: Far too slow!

 

[Chapster5]

BOOM worked A charm guys! Thank you