replacing #NA with 0

[blakcat]

Hello everyone,does anyone know how to replace the #NA with 0 in
Vlookup function. So that when the numbers don't match 0 replaces th
#NA symbol in the column so that the numbers are easier to add up

 

[Dave Peterson]

=if(isna(yourvlookupformula),0,yourvlookupformula)

 

[papou]

Hi
Use ISNA(Value) e.g.:
=IF(ISNA(VLOOKUP(A1,A1:F50,2,FALSE)),0,VLOOKUP(A1,A1:F50,2,FALSE))

HTh
Cordially
Pascal

 

[blakcat]

Thanks that worked...appreciate your tim