| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date formulas | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| how can i multiply two columns | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
