Looking up a table value based on two conditional option buttons
 

I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the
contract volume (row) and the contract length (column). My sales reps input
the contract volume and length by selecting OptionButtons in another
worksheet within this workbook.

Can I code a macro to take the selections from those two OptionButtons,
select the corresponding percentage, and output it for use in my pricing
equation?

Looking up a table value based on two conditional option buttons
 

On Jun 23, 1:58*pm, Pristan wrote:
I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the
contract volume (row) and the contract length (column). My sales reps input
the contract volume and length by selecting OptionButtons in another
worksheet within this workbook.

Can I code a macro to take the selections from those two OptionButtons,
select the corresponding percentage, and output it for use in my pricing
equation?

sure. we would need more specifics to tell you how to code this. Also,
this seems like something that could be done with standard formulas
within excel, without the need for a macro.

Looking up a table value based on two conditional option butto
 

I am new to VBA so it is very possible this could be done without macros so
either way I can set it up will be fine with me.

I've included an example of what I'm working with below. The contract price
is calculated by multiplying the unit price, volume, discount % and the # of
years in the contract all together. It's not complicated however I'd like to
keep the form with OptionButtons on one sheet and the calculation on another
sheet.

Currently the salesforce would select the # of years on one button and the
volume on another. I'd like those two selections to output the corresponding
% to another cell for calculating the contract price.

Years
1 2 3 4
Volume 5000 100% 95% 90% 85%
10000 80% 75% 70% 65%
15000 60% 55% 50% 45%
20000 40% 35% 30% 20%

Contract Price $18,750

Unit Price $2.50


"A Mad Doberman" wrote:

On Jun 23, 1:58 pm, Pristan wrote:
I have a table of percentages from which I need to output a single percentage
as part of a pricing equation. This single number is chosen by selecting the
contract volume (row) and the contract length (column). My sales reps input
the contract volume and length by selecting OptionButtons in another
worksheet within this workbook.

Can I code a macro to take the selections from those two OptionButtons,
select the corresponding percentage, and output it for use in my pricing
equation?

sure. we would need more specifics to tell you how to code this. Also,
this seems like something that could be done with standard formulas
within excel, without the need for a macro.