Thread: Is there a function to link a cell to a fomula?

New to the forums after spending the last 4 hours on the net trying to figure out a way to work something into my sheet. Below is a screen shot sample of something similar to what I am working on and what I need to do (hopefully):

Screen Shot

Basically I there are improvements and declines seen in the data given the persons age from the previous years data. What I want to be able to do is have the cell B1 with an Age put in between 18 and 35. Then the Cells between B8 through D8 call upon the improvement/decline from the chart below. To make it easy I have the ages correlating to the actual row that its in (age 18's improvements are in Row 18 and so on).

So, is there something very simple that I am overlooking here? I tried nesting it together, but obviously its too many sets since you can only nest 7 at a time.

Anyways, thanks for any help if someone can provide it. If not, thanks for looking anyways and trying.

Using your screenshot as an example you can use a standard INDEX:

B8: =IF($B$1<18,"N/A",INDEX(B$18:B$35,$B$1-17,1))

The above can be copied to C8:D8

The formula of DonkeyOte works fine. I've done it with LOOKUP

=LOOKUP($B$1,$A$13:$A$30,B13:B30)

Hi Dougdirt and welcome to the board
In the future it might be easier to post a small xls file of your data. In that way responding members won't have to type data in themselves to check if the answer they submit works

Thx