Lookup Tables

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

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[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))