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?
|