|
Lkup formula is returning last value in result column, not lkup va
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! |
Lkup formula is returning last value in result column, not lkup va
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! ================================================== === "irvine79" wrote in message ... 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! |
Lkup formula is returning last value in result column, not lku
Awesome! Thanks.
"RagDyeR" wrote: 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! ================================================== === "irvine79" wrote in message ... 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! |
Lkup formula is returning last value in result column, not lku
Thanks for the very quick feed-back.<bg
-- Regards, RD ----------------------------------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! ----------------------------------------------------------------------------------------------- "irvine79" wrote in message ... Awesome! Thanks. "RagDyeR" wrote: 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! ================================================== === "irvine79" wrote in message ... 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! |
| All times are GMT +1. The time now is 10:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com