Snasui Excel Forum

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,

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.

Hi Dear

Thanks it works well
Is it possible to use Choose?

Best wishes,

Yes, you can do it with 'Choose'.

For example on C3

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

Thanks again

Best wishes,