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

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