exact match
VLOOKUP and INDEX with MATCH. Both
gave me N/A errors.

Did you specify in the formulas that you wanted an exact match?

=VLOOKUP(A1,D1:E10,2,0)
=INDEX(E1:E10,MATCH(A1,D1:D10,0))

The 0 in each formula means you want an exact match.

With LOOKUP, you can't specify that you want an exact match. If an exact
match isn't found it returns an approx match by default. Also, using LOOKUP,
the lookup_vector *must* be sorted in ascending order.


--
Biff
Microsoft Excel MVP


"robertbjr" wrote in message
...
I have been using the LOOKUP function for a long time. It worked with very
little problems in Excel 2003. I am having a problem in Excel 2007. For
some reason it will not give me an exact match. It will only return a
value
that is approximate. I have tried using VLOOKUP and INDEX with MATCH.
Both
gave me N/A errors. Does anyone have any suggestions on how to get an
exact
match using LOOKUP in Excel 2007? Thank you.