I
irvine79
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!
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!