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!