I have looked through all the other posts and found some great answers but
not exactly what I need, so if anyone can solve this for me that would be
great.

Thanks in advance

I have the follow data and want to return the result based on 3 lists.
d2 contains dealer or branch in pick list
d3 contains 10% cancel, 5% cancel or 10% fmv in a pick list.
d4 months in a pick list
I would like to get the correct rate based on the selections.
ie, dealer + 10% fmv + 36 mth would return .03108
or branch + 10% fmv + 36 myhs would return .03280
and any combination of.



Dealer Months 10% Cancel5% Cancel10% FMV
24 0.05660 0.05126 0.04426
36 0.04318 0.03755 0.03108
39 0.04118 0.03546 0.02905
48 0.03678 0.03083 0.02452
51 0.03570 0.02967 0.02336
60 0.03318 0.02691 0.02061
63 0.03252 0.02618 0.01987
Branch 24 0.05747 0.05126 0.04595
36 0.04411 0.03755 0.03280
39 0.04212 0.03546 0.03079
48 0.03777 0.03083 0.02629
51 0.03670 0.02967 0.02514
60 0.03422 0.02691 0.02242
63 0.03358 0.02618 0.02169