V Lookup nil return value

**Dave_A** · 02-28-2007, 06:46 AM

i am creating a business day list to pull figures from a table, im using vlookup for this and it is returning public holidays in a #NA value as it cant find the values in the table, is there any way how i can just make it return a 0 value instead as the #NA is mucking up proceeding formulas...

be much help if you can provide assistance...
cheers

**starguy** · 02-28-2007, 07:33 AM

Originally Posted by Dave_A

i am creating a business day list to pull figures from a table, im using vlookup for this and it is returning public holidays in a #NA value as it cant find the values in the table, is there any way how i can just make it return a 0 value instead as the #NA is mucking up proceeding formulas...

be much help if you can provide assistance...
cheers

=if(iserror(your_formula),0,(your_formula))

replace "your_formula" with actual VLOOKUP formula you use.

here is example

=IF(ISERROR(VLOOKUP(D2,$A$1:$C$12,3,FALSE)),0,(VLOOKUP(D2,$A$1:$C$12,3,FALSE)))