I have a workbook, in Excel, that has a credit disability insurance
calculator in it that calculates the premium based on the term and amount
financed. I already have the term pulling from another sheet within the
workbook but I don't know what formula to use to pull the correct factor
(based on the term) from another worksheet within the workbook. There are 85
different factors that can be used depending on the term of the loan. Can
someone help me?