http://www.freefilehosting.net/download/3eec0
<a href="http://www.freefilehosting.net/files/3eec0"Croy Test
Spreadsheet.xls</a
Croy Test
Spreadsheet.xls

Max

Links attached. I'm trying to calculate a value in cell e14. I want that
number to be calculated based on the numbers entered in cells G2 and K2 and
then the number on the factor tab. For example, for the 2 numbers listed in
G2 and K2, the value should be .025 (highlighted in yellow). That factor
should then be multiplied by the number in E12.

The complication is I want to be able to change the numbers in G2 and/or K2,
and the formula will go to the correct cell on the factor tab and return the
correct factor to the formula in cell e 14.

Let me know if any of that makes sense. Thanks.



"Max" wrote:

Tough for me to visualize your set-up. And you seem to have expanded the
scope of your original query.

Can you upload your sample* and post a link to it here?
*desensitized as appropriate

You could use:
http://www.freefilehosting.net/

Copy the direct link which is generated after you upload your sample,
then paste it into your reply here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Michael Croy" wrote in message
...
Hi Max

Thanks, I think I'm getting close. I need to better describe my issue:

One sheet 1, I want to enter the number of payments (3 choices) in cell
G7.
Also on sheet 1, I want to enter the age in cell K7.
Then I'm going to calculate a payment in cell E19. To calculate the
payment, I need to multiply a total price (cell E17) by the result of the
lookup.

The lookup is on sheet 2. The table has Age in column A. Row 1 B, C and
D
have the three payment choices. I want the formula in cell E19 of sheet 1
to
look at the table on sheet 2, and return a value based on the age and
payment
information listed in sheet 1's K7 and G7 cells.

I seem to be able to look up and populate other tables, but not have a
variable that changes based on the input I make into the age and payment
number cells.

Can you help with that?