Mar 29 2020 12:15 PM
If I have a grid, what formula would I use to return a value to a cell based upon two lookup criteria?
Example: I want to use volume and % as the perimters to retrieve a number - say the volume is 525,000 the the % is 12.49%, how do I get another cell to become populated with 1.00%, of if the % was 13.47%, the cell would then populate to 1.45%. Thanks
Grid | % | ||||||
1.00% | 0.00% | 12.00% | 13.00% | 14.00% | 15.00% | 16.00% | 17.00% |
Volume | 12.99% | 13.99% | 14.99% | 15.99% | 16.99% | 17.99% | |
$500,000.00 | $749,999.99 | 1.00% | 1.45% | 1.90% | 2.35% | 2.75% | 3.10% |
$750,000.00 | $999,999.99 | 1.01% | 1.46% | 1.91% | 2.36% | 2.76% | 3.11% |
$1,000,000.00 | $1,249,999.99 | 1.02% | 1.47% | 1.92% | 2.37% | 2.77% | 3.12% |
$1,250,000.00 | $1,499,999.99 | 1.03% | 1.48% | 1.93% | 2.38% | 2.78% | 3.13% |
$1,500,000.00 | $1,749,999.99 | 1.04% | 1.49% | 1.94% | 2.39% | 2.79% | 3.14% |
$1,750,000.00 | $1,999,999.99 | 1.05% | 1.50% | 1.95% | 2.40% | 2.80% | 3.15% |
$2,000,000.00 | $2,499,999.99 | 1.06% | 1.51% | 1.96% | 2.41% | 2.81% | 3.16% |
$2,500,000.00 | $2,999,999.99 | 1.07% | 1.52% | 1.97% | 2.42% | 2.82% | 3.17% |
$3,000,000.00 | $3,499,999.99 | 1.08% | 1.53% | 1.98% | 2.43% | 2.83% | 3.18% |
$3,500,000.00 | $3,999,999.99 | 1.09% | 1.54% | 1.99% | 2.44% | 2.84% | 3.19% |
Mar 29 2020 11:22 PM