How to pick values in xl sheet for ltcg index

Use the Index Function with Match Function

1) type  1981-82  to 2015-16  in cells say M1 to M35

2) type  100 to  1081 in cells besides it  i.e N1 to N35

3)  Allow data value as Lists for drop down for M1 to M35

      say in cell  A4 =  Year of Purchase then

      in cell  c4  allow drop list . i.e Data -->Data validation-->select data valid 

    Validation critria seelct  list . In source  type  =$m$1:$m$35 --> Ok

Now cell C4 can take values from 1981-82 , 1982-83 ........2015-16  as a drop dowm list

4)  Now in cell d4 say type      =INDEX($M$1:$N$35,MATCH(C4,M$1:M$35,0),2) 

    a) $m$1 is the start of the range till $n$35

     b) C4 is the year selected from drop dowm list

     c) m$1: m$35 is range where c4 lies. & 0 is for exact match

     d) 2 is the second column (Index values) which is automatically filled for corresponding year selected in C4.

i Hope this is clear     

If the table consits of 3 Columns  then give 3 for match function ??

Whether S.no 3 and  4  should be repeated for 

Improvement  and then  Sale of property.?

Thats what I meant . copy and paste for s.no  3 and 4  for Improvment and Sale.

Uploaded  the XL sheet  . Any improvement is most welcome

Share it  freely.   XL version is 2010. 

Thanks Mr Shiroor

In s.no  4 you can use the Vlookup function instead of index and match as follows

=VLOOKUP(C4,$M$1:$N$35,2)

C4 is the year you picked from drop down list

$m1:$n$35 is the table range of values

2 is column number where you are looking for corresponding value for C4.