Vertical Lookup Question

J

Jennifer

Good day, I have a quick question. When using a vertical lookup that looks
at a named table for the returned values, if the item is not present in the
table it returns an N/A. Is there any way to have it return a zero (0) if it
is not present in the table?
 
M

Mike H

You might try:-

=IF(ISNA(VLOOKUP(368.59,myrange,2,FALSE)),"0",VLOOKUP(368.59,myrange,2,FALSE))

Mike
 
D

Don Guillett

try
IF(ISNA(yourformula)),0,yourformula)
or
IF(ISNA(yourformula)),"",yourformula)
 
S

Sebation.G

u can use IF()&ISERROR()orISNA() to reture to zero when lookup() function
returns an N/A
i.e =IF(iserror(lookup()),0,lookup())
 
M

Mike H

Jennifer,

It's just happened to be a value I had in a named range to test the formula.
It's the lookup value.

Mike
 
Top