jski
Board Regular
- Joined
- Jan 11, 2006
- Messages
- 118
Good morning Mr. Excel team,
I'm trying to develop a formula that would permit me to lookup a value within a dollar range (Revenue Growth), a percentage range (% Growth), and return in an award amount (Payout). The table looks like this:
<tbody>
</tbody><colgroup><col><col span="4"></colgroup>
I'm trying to develop a formula that would permit me to lookup a value within a dollar range (Revenue Growth), a percentage range (% Growth), and return in an award amount (Payout). The table looks like this:
Revenue Growth | % Growth | Payout | |||
From (A3) | To |
<tbody> </tbody> | To | ||
$500,000 | $749,999 | 15.00% | 1000000% | 3.75% | |
$500,000 | $749,999 | 10.00% | 14.99% | 2.75% | |
$500,000 | $749,999 | 8.00% | 9.99% | 2.25% | |
$500,000 | $749,999 | 7.00% | 7.99% | 1.75% | |
$500,000 | $749,999 | 6.00% | 6.99% | 1.50% | |
$500,000 | $749,999 | 0% | 5.99% | 0% | |
$750,000 | $999,999 | 11.00% | 14.99% | 3.75% | |
$750,000 | $999,999 | 7.00% | 10.99% | 2.75% | |
$750,000 | $999,999 | 6.00% | 6.99% | 2.25% | |
$750,000 | $999,999 | 5.00% | 5.99% | 1.75% | |
$750,000 | $999,999 | 4.00% | 4.99% | 1.50% | |
<tbody> </tbody> | $999,999 | 0% | 3.99% | 0% | |
$1,000,000 | 100,000,000 | 10.00% | 11% | 3.75% | |
$1,000,000 | 100,000,000 | 6.00% | 9.99% | 2.75% | |
$1,000,000 | 100,000,000 | 5.00% | 5.99% | 2.25% | |
$1,000,000 | 100,000,000 | 4.00% | 4.99% | 1.75% | |
$1,000,000 | 100,000,000 | 3.00% | 3.99% | 1.50% (E20) | |
I assume an array formula? Thanks. |
<tbody>
</tbody><colgroup><col><col span="4"></colgroup>