Hello All,

I'm hoping I can get some help on this. I have been trying and still can't seem to have the right formula or logic. I did a vlookup based on years of service to get the rate but I also want to put in a logic that if the years of service is greater than 22, than the rate should reflect the rate showing in years of 22.

Hope this make sense.



Yrs. Of Service & Rates
0 $33.32
1 $34.16
2 $35.02
3 $35.89
4 $36.78
5 $37.71
6 $38.65
7 $39.62
8 $40.61
9 $41.62
10 $42.67
11 $43.00
12 $43.33
13 $43.65
14 $43.95
15 $44.25
16 $44.53
17 $45.22
18 $45.92
19 $46.62
20 $47.79
21 $48.98
22 $50.21