Thanks for the very quick feed-back.<bg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"irvine79" wrote in message
...
Awesome! Thanks.

"RagDyeR" wrote:

Are the values in Column A sorted *ascending*?

That's one of the requirements of Lookup().

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"irvine79" wrote in message
...
I have a lookup formula with a lookup value on sheet 1 and both lookup
vector
and result vector are on sheet 2. The cell with the formula is on sheet 1.

formula - =LOOKUP(B1,Sheet2!!A2:A4,Sheet2!G2:G4)

the formula returns the last value from column G when it should be
returning
the value in G2. Help!