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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Explain N/A in Vlookup 2
Multiple IF Statement 2
VLookup question 4
VLookup Function HELP 7
VLOOKUP forumla for Excel HELP! 1
Set add function ignore #N/A 1
Return a 0 when vlookup returns #n/a 2
vlookup - can't find match 1

Back
Top