I have three columns of data that make up something similar to a two-life actuarial table. Column A is for the younger of the two lives, Column B is for the older of the two lives, and Column C has a rate associated with the combination of ages.

I am trying to develop a formula so that if I am given a birthdate or an age, the spreadsheet will look to these three columns to pull the appropriate age.


See the attached excel file and pic.
ExcelTable.JPG


Rate Table Lookup.xlsx