Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookdown cell vertically, return horizontal value
Hi, I have a spreadsheet that vaguely looks some thing like following A B C D 1 jan 02 34 2 jan 02 56 3 jan 02 34 1 feb 02 67 2 feb 02 55 3 feb 03 In cell d I would like to be able to find the next value of A ( lookup from feb 02 to feb 02) return the value from C and then perform a calculation to find the variance month to month. I cannot use an absolute reference because different months have a variation in the number of records. Is there a function or part of a function that allows me to do this? most of my experience has come from access so appologies if this is a really straight forward answer, as i have no idea what to look for i have had a pretty poor time searching -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=518180 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookdown cell vertically, return horizontal value
Cereldine,
Use MATCH (similar in use to VLOOKUP) to find the row number & INDEX to return the cell. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "cereldine" wrote: Hi, I have a spreadsheet that vaguely looks some thing like following A B C D 1 jan 02 34 2 jan 02 56 3 jan 02 34 1 feb 02 67 2 feb 02 55 3 feb 03 In cell d I would like to be able to find the next value of A ( lookup from feb 02 to feb 02) return the value from C and then perform a calculation to find the variance month to month. I cannot use an absolute reference because different months have a variation in the number of records. Is there a function or part of a function that allows me to do this? most of my experience has come from access so appologies if this is a really straight forward answer, as i have no idea what to look for i have had a pretty poor time searching -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=518180 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you make cell 2 return data if cell 1 contains text? | Excel Discussion (Misc queries) | |||
If it's not a space, return the cell contents. | Excel Worksheet Functions | |||
Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Find a value in a cell and return another value in a differant cel | Excel Discussion (Misc queries) | |||
return zero from a blank cell | Excel Worksheet Functions |