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