Excel 2000 - lookup
 

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

Excel 2000 - lookup
 

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
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.
--
Richard

Excel 2000 - lookup
 

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


"Max" wrote:

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
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.
--
Richard

Excel 2000 - lookup
 

Glad that resolved it for you !
Thanks for calling back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
Thank you Max. That was the problem, B1:B6 weren't in ascending order.
Everthing works fine now.
--
Richard