Lookup Tables

K

KevinE

I have a specific Table set up and I need to return '0' if an item is
not found within
that Table and the correct value if it is. Considering that VLOOKUP
will return an error if it can't find something, I was wondering what
the best method would be.

many thanks,
Kevin.
 
N

Norman Harker

Hi Kevin:

Here's an example:

=IF(ISNA(VLOOKUP(A1,H1:I15,2,FALSE)),0,VLOOKUP(A1,H1:I15,2,FALSE))


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
J

J.E. McGimpsey

If your lookup is in one column (so that you're using VLOOKUP()),
here's one way:

Assume your vlookup is =VLOOKUP(A1, J1:K100, 2, FALSE). then:

=IF(ISNA(MATCH(A1,J1:J100,FALSE)),0,VLOOKUP(A1,J1:K100,2,FALSE))
 
Top