iferror alternative Excel 2003

[Shaun]

Hi Everyone

I am using a vlookup to consolidate what will eventually be 4 quarters of financial information. When a value is not available I am getting the error #N/A which I would like to replace with a 0.

In Excel 2003 there is the ERROR.TYPE() function which I have tried to manipulate so that when the vlookup returns #N/A a 0 is substituted. I have failed miserably.

Any ideas/alternatives?

Cheers

Shaun

 

[Nebu]

Hi:
Use the below formula
=IF(ISERROR(VLOOKUP(B4,'Q1'!$B$6:$D$18,3,FALSE)),0,VLOOKUP(B4,'Q1'!$B$6:$D$18,3,FALSE))
Thanks

 

[Shaun]

Hi:
Use the below formula
=IF(ISERROR(VLOOKUP(B4,'Q1'!$B$6:$D$18,3,FALSE)),0,VLOOKUP(B4,'Q1'!$B$6:$D$18,3,FALSE))
Thanks

Hi Nebu

That worked an absolute treat. Thank you, I very much appreciate it.

Cheers

Shaun