VLOOKUP returns #N/A but want a blank instead

  • Thread starter Thread starter Golf Club
  • Start date Start date
G

Golf Club

I want to have a blank field return instead of #N/A when
my VLOOKUP is false. How would I change my current
formula to do that? Here is the formula currently used:
=VLOOKUP(A10,DC$7:DH$801,4,1)*D10

Any help would be appreciated.
 
Hi
try
=IF(ISNA(VLOOKUP(A10,DC$7:DH$801,4,1)),"",VLOOKUP(A10,DC$7:DH$801,4,1)*
D10)
 
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

#N/A 5
VLOOKUP returning #N/A result 2
EXCEL - IF(IFERROR(VLOOKUP question 0
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"",VLOOKUP(F2,Mast 3
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con 4
VLOOKUP - 0 instead of # N/A 8
=IF(Input_Sheet!D52="","",Input_Sheet!D52) 2
Vlookup - N/A 4

Back
Top