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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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!
 
Back
Top