Lookups - how to return zero?

[james.cowan]

Hello!

I am currently doing a lot of vlookups in spreadsheets, but on some occasions the lookup will return #N/A. I realise this means that there is nothing to match the lookup with, but in this instance is it possible to get the#N/A to simply appear as a zero instead?

Thanks.

 

[PaddyD]

whatever anyone says, do not use an isna() or iserror() construct:

http://www.mrexcel.com/board2/viewtopic.php?t=62102

 

[masim]

Hello

try this

=if(isna(your vlookupformula)),0,(your vlookupformula)))

search for ISNA in help too.

Regards
Asim

 

[james.cowan]

Thanks...that worked nicely.