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

  • Thread starter Thread starter sokevin
  • Start date Start date
S

sokevin

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


thanks :confused
 
sokevin

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

Gord Dibben Excel MVP
 
Back
Top