vlookup??? HELP!!!

Copper Contributor

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.991.00%1.45%1.90%2.35%2.75%3.10%
$750,000.00$999,999.991.01%1.46%1.91%2.36%2.76%3.11%
$1,000,000.00$1,249,999.991.02%1.47%1.92%2.37%2.77%3.12%
$1,250,000.00$1,499,999.991.03%1.48%1.93%2.38%2.78%3.13%
$1,500,000.00$1,749,999.991.04%1.49%1.94%2.39%2.79%3.14%
$1,750,000.00$1,999,999.991.05%1.50%1.95%2.40%2.80%3.15%
$2,000,000.00$2,499,999.991.06%1.51%1.96%2.41%2.81%3.16%
$2,500,000.00$2,999,999.991.07%1.52%1.97%2.42%2.82%3.17%
$3,000,000.00$3,499,999.991.08%1.53%1.98%2.43%2.83%3.18%
$3,500,000.00$3,999,999.991.09%1.54%1.99%2.44%2.84%3.19%
3 Replies

@Rick_Miller A combination of INDEX and MATCH would do the trick. Please see the attached workbook.

 

 

 

 

THANKS!!!!@Riny_van_Eekelen 

@Rick_Miller WELCOME!!