Excel 2000 - lookup

R

Richard

I am trying to use lookup or vlookup to reference a list of values as follows:
Column E are the values to search for, Column D are the formulas (which I
need to drag down to produce the values I need in the order I need them),
Column B holds the values to be found and Column C holds the values to be
returned. The problem is the formula returns the wrong value in Column D.

=LOOKUP(E1,B1:B6,C1:C6)

Many thanks in advance.
 
M

Max

.. The problem is the formula returns the wrong value in Column D.
=LOOKUP(E1,B1:B6,C1:C6)
Click to expand...

Just a guess ..
Are the values in B1:B6 (the lookup vector) placed in ascending order ?

Reference this note below from Excel's help:
Important: The values in lookup_vector must be placed in ascending order:
....,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give
the correct value. Uppercase and lowercase text are equivalent.
 
R

Richard

Thank you Max. That was the problem, B1:B6 weren't in ascending order.
Everthing works fine now.
 
Top