rent calculation

[sna]

Dear All,
I have the following criteria
Criteria Rental Oil Repair
Currently 18 11 15
1 year before currently 14 10 15
2 year before currently 13 10 15
3 year before currently 11 7 15
4 year before currently 10 5 15

I need to calculate rental,oil and repair for Motor plate no. 1K9856 Series Year 2018?
The result would be Rental 13,Oil 10 and repair 15.
I don't need a helper column?
Is there any formula?

Best regards,

[snasui]

On C3 should be

=INDEX(B7:B11,YEAR(TODAY())-$B3+1)

Press enter and adapt the highlighted part of formula above for use with E3 and F3.

[sna]

Hi Dear

Thanks it works well
Is it possible to use Choose?

Best wishes,

[snasui]

Yes, you can do it with 'Choose'.

For example on C3

=CHOOSE(YEAR(TODAY())-B3+1,B7,B8,B9,B10,B11)

[sna]

Thanks again

Best wishes,