Say, for example, I have a list of interest rates and the more people I sign up to my program, the higher my interest rate is. The time money would be invest for, is on the left-hand side, and the amount of people signed up is on the top.

The items listed down on the left-hand side are as follows:
~ Weekly
~ Fortnightly
~ Monthly
~ 2 Months
~ 3 Months

The top of the cells are from 1 - 10.

The interest increase both as they go down, and across to the right.



My question about this, is if I were to have a different table, and in that table I have people who sign up people, and I have (I have cell referenced each part)

A1 - Name
A2 - People signed up
A3 - Interest rate

B1 - John
B2 - 3
B3 - (the interest rate)

C1 - Aimee
C2 - 7
C3 - (the interest rate)



I was to know that from the first table set up, how can I get Column 3 to represent the cell from the amount of people that have signed up. So, that in Column 3, the interest rate that is shown is from the first table, and gets the amount of interest from the people signed up.

No, it's not just simple "cell referencing" because I want the interest rate to be based on both the, time period, and how many people signed up, and I want it to be automatic instead of me doing it manually.

Is it possible?

NOTE: Here is a perfect example of what I want to achieve, just some things change.

I'm not an Excel guru but I'm sure that you could make something work with either a combination of VLookup and HLookup or just Hlookup and an if statement.

Here's a pretty good link on embedded vlookups. hlookups work the same way except it searches by the row rather than a column.

http://pubs.logicalexpressions.com/Pub0009...icle.asp?ID=446

You can find here some more info regarding the vlookup function:
vlookup Excel
its a part of the following site:
Microsoft Office Excel tutorial videos