I have a situation where I have a list of items listed vetically as
follows in excel eg

A B C

1 Month Principal Interest
2
3 April 300 50
4 May 400 40
5 June 500 30
6 July 600 20
7 August 700 10

However I have a table that is created as follows

A B C
D
9
10 April Principal May Principal June Principal
July Principal
11
12 =B3

I want to copy the formula in Cell A12 to B12, C12 and D12 such that it
will automatically recognise cell B4 for May principal and cell B5 for
June Principal etc. My spreadsheet in reality is very large so
achieving this will cut down the amount of work I have to do.

Thanks


--
neilangelo
------------------------------------------------------------------------
neilangelo's Profile: http://www.excelforum.com/member.php...fo&userid=3504
View this thread: http://www.excelforum.com/showthread...hreadid=506747