First I want to say I have read many posts and tried many suggestions on
those post before posting my question hoping I wouldn't have to ask a
question that has been answered several times already.

I am creating an Excel workbook for my business math class. On one page is
the actual math problems and on the other two sheets, each one has a table.
One table is Present value of $1 and the other is Future Value of a $1. When
I try and put a formula in the math problem sheet that is referenced to one
of the tables I get #NA or one of the many other error messages.

Here is an example of what I need:

Math problem is: what is the present value if in 3 years I have $15,000.00
that received 6% interest compounded quarterly.

To figure this out I have to find the compound interest and the periods of
that interest. To do this I have to take R/T or 6%/4 which is 1.5% and then
multiply the years by the compound periods 3*4 which is 12.
Once I work this out on my math sheet I need to go to the PVTable which is
my present value table and fine the periods which is 12 in the first column,
and the compound interest which is 1.5% in the first row and get the table
value where the two intersect. Because I need to be able to change the
interest and compound periods and priciple or future amounts without having
to solve all over again.

I thought it was going to be much simpler than it has proven to be but no
matter which formula I use I get an error. This was the last few I used from
other post suggestions:

=INDEX(table range including headers,MATCH(value in column,column
range,0),MATCH(row value,row range,0))

=INDEX(your range,MATCH(row value,rows to look in),MATCH(column
value,columns to look in))

=INDEX('Penalty Table'!$A$7:$F$26, MATCH($A2,'Penalty Table'!$A$7:$A$26,),
MATCH(B$1,'Penalty Table'!$A$7:$F$7,))


And several others as well. Please help me before I go crazy. I even took
an excel class two terms ago that went over all of this and I got an A, so
much for that.

Thank you
Candie