anonymos105
Thread Starter
- Joined
- May 6, 2005
- Messages
- 30
I am working on a spreadsheet that calculates life insurance rates and I can't for the life of me get this formula to work. Here is the situation
I need it to take the age shown in column d of sheet 1
It needs to find that age in column 1 of sheet 2 and return the matching result in column 2 of sheet 2
this all needs to appear in column L of sheet 1
so for example
cell L2 needs to show the rate that applies to employee 1
in cell D2 it has his age of 60
I need L2 to take the age of 60 in cell D2 find that age in sheet 2 column 1 (in this case A47) and return the corresponding rate in sheet 2 B47 (in this case $1.21)
Can anybody help with this, everytime I have tried to figure out the formula I get some random number thats not even on any of the spreadsheets.
I need it to take the age shown in column d of sheet 1
It needs to find that age in column 1 of sheet 2 and return the matching result in column 2 of sheet 2
this all needs to appear in column L of sheet 1
so for example
cell L2 needs to show the rate that applies to employee 1
in cell D2 it has his age of 60
I need L2 to take the age of 60 in cell D2 find that age in sheet 2 column 1 (in this case A47) and return the corresponding rate in sheet 2 B47 (in this case $1.21)
Can anybody help with this, everytime I have tried to figure out the formula I get some random number thats not even on any of the spreadsheets.