How To Do Vlookup But Have The #n/a Be 0

[sokevin]

hi, does anyone know how to make vlookup instead of #n/a it appears a
(zero)


thanks :confused

 

[Gord Dibben]

sokevin

=IF(ISNA(VLOOKUP(value,table,col,FALSE)),0,VLOOKUP(value,table,col,FALSE))

Gord Dibben Excel MVP

 

[sokevin]

thank moit :