Lkup formula is returning last value in result column, not lkup va

[Guest]

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!

 

[RagDyeR]

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!
=====================================================

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!

 

[Guest]

Awesome! Thanks.

 

[RagDyeR]

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