Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup value and return column offset value
I have the following table that I need to lookup a value. I am trying to use
the =MATCH(G1,LLTable,0) formula to lookup the G1 date 04/03/2009 in the LLtable below and return the CWW value to the left of each row. Col "A" Col "B" Col "C" Col "D" CWW 1 Mar 16, 2009 Apr 06, 2009 Apr 27, 2009 CWW 2 Mar 20, 2009 Apr 10, 2009 May 01, 2009 CWW 3 Mar 23, 2009 Apr 13, 2009 May 04, 2009 CWW 4 Mar 27, 2009 Apr 17, 2009 May 08, 2009 CWW 5 Mar 30, 2009 Apr 20, 2009 May 11, 2009 CWW 6 Apr 03, 2009 Apr 24, 2009 May 15, 2009 So if the formula above was to work as designed, it would lookup 04/03/2009 in the table and return the corresponding value from column "A" of CWW6. I am not sure if I should be using a combination MATCH/OFFEST combo. Can someone guide through this please? Thanks Tony |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find max value in column and return offset of that value | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Lookup a row and column and return value | Excel Worksheet Functions | |||
offset 1 row and return to first column | Excel Discussion (Misc queries) | |||
lookup from one column return value from another? | Excel Discussion (Misc queries) |