Im working on a pricing spreadsheet that calculates the price based on the
amount of exposure that we are subjected to. I have the pricing scale that
assigns a pricing factor to the exposure. Here is a small, hypothetical
sample:

Exposure % Factor
10% 0.9
20% 0.8
30% 0.7
40% 0.6
50% 0.5

The actual list has nearly 200 different exposure % and factors.

I can easily calculate the exposure % in excel, but I want to find a way to
make that exposure % reference the corresponding factor automatically in
another cell. Any suggestions?

Take a look at VLOOKUP or LOOKUP in XL's help file, they sound like what
you're looking for.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jake" wrote:

Im working on a pricing spreadsheet that calculates the price based on the
amount of exposure that we are subjected to. I have the pricing scale that
assigns a pricing factor to the exposure. Here is a small, hypothetical
sample:

Exposure % Factor
10% 0.9
20% 0.8
30% 0.7
40% 0.6
50% 0.5

The actual list has nearly 200 different exposure % and factors.

I can easily calculate the exposure % in excel, but I want to find a way to
make that exposure % reference the corresponding factor automatically in
another cell. Any suggestions?