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

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top