It always helps if you can quote specific cell references that YOU
use, so that the formulae we suggest are tailored to your situation.
Without that we have to make assumptions regarding the data layout,
which you then have to translate into your worksheet.

So, assuming your table of interest rates is in a sheet called Data
and occupies A1:E3, and that a Calculation sheet is used to record the
State in B1 (better to have a validation drop-down here) and the Loan
Issue Date in B2, and that you want to return the appropriate interest
rate to cell B3, then put this in B3:

=IF(OR(B1="",B2=""),"",INDEX(Data!
B2:E3,IF(YEAR(B2)<=1984,1,2),MATCH(B1,Data!B1:E1,0 ))

Hope this helps.

Pete



On Oct 13, 8:55*pm, C.W. wrote:
I have the following:

A table with the following data:
* * * * * * * * * * * * * AR * * *LA * * MS * * *OK

<12/31/1984 *8.00% * 8.00% * 8.00% * 7.00%

12/31/1984 *6.00% * 6.00% * 8.00% * 6.00%

I also have the two variables in which I would like to look up on a
calculation worksheet that uses the data from above in an interest
calculation. *The varaibles are as follows and can change depending on the
state in which the loan is being calculated:

State: *MS

Loan Issue Date: *01/15/1979

What I am looking for is to be able to automatically populate a cell based
on the variable input. *I want the cell to autopopulate by looking at the
variables and cross referencing the variables to the table based on the state
and the issue date so that the person doing the calculation only has to fill
in information and nothing else.

Thanks,

C.W.