Highlighted
New Contributor

# vlookup??? HELP!!!

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%
3 Replies
Highlighted

# Re: vlookup??? HELP!!!

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

Highlighted

# Re: vlookup??? HELP!!!

THANKS!!!!@Riny_van_Eekelen

Highlighted

# Re: vlookup??? HELP!!!

@Rick_Miller WELCOME!!