VLOOKUP returns #N/A but want a blank instead

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.
 
F

Frank Kabel

Hi
try
=IF(ISNA(VLOOKUP(A10,DC$7:DH$801,4,1)),"",VLOOKUP(A10,DC$7:DH$801,4,1)*
D10)
 
Top