vlookup??? HELP!!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1262816%22%20slang%3D%22en-US%22%3Evlookup%3F%3F%3F%20HELP!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262816%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20have%20a%20grid%2C%20what%20formula%20would%20I%20use%20to%20return%20a%20value%20to%20a%20cell%20based%20upon%20two%20lookup%20criteria%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20I%20want%20to%20use%20volume%20and%20%25%20as%20the%20perimters%20to%20retrieve%20a%20number%20-%20say%20the%20volume%20is%20525%2C000%20the%20the%20%25%20is%2012.49%25%2C%20how%20do%20I%20get%20another%20cell%20to%20become%20populated%20with%201.00%25%2C%20of%20if%20the%20%25%20was%2013.47%25%2C%20the%20cell%20would%20then%20populate%20to%201.45%25.%20Thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22642%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22117%22%3EGrid%3C%2FTD%3E%3CTD%20width%3D%22117%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%25%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2268%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E1.00%25%3C%2FTD%3E%3CTD%3E0.00%25%3C%2FTD%3E%3CTD%3E12.00%25%3C%2FTD%3E%3CTD%3E13.00%25%3C%2FTD%3E%3CTD%3E14.00%25%3C%2FTD%3E%3CTD%3E15.00%25%3C%2FTD%3E%3CTD%3E16.00%25%3C%2FTD%3E%3CTD%3E17.00%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EVolume%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E12.99%25%3C%2FTD%3E%3CTD%3E13.99%25%3C%2FTD%3E%3CTD%3E14.99%25%3C%2FTD%3E%3CTD%3E15.99%25%3C%2FTD%3E%3CTD%3E16.99%25%3C%2FTD%3E%3CTD%3E17.99%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%24500%2C000.00%3C%2FTD%3E%3CTD%3E%24749%2C999.99%3C%2FTD%3E%3CTD%3E1.00%25%3C%2FTD%3E%3CTD%3E1.45%25%3C%2FTD%3E%3CTD%3E1.90%25%3C%2FTD%3E%3CTD%3E2.35%25%3C%2FTD%3E%3CTD%3E2.75%25%3C%2FTD%3E%3CTD%3E3.10%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%24750%2C000.00%3C%2FTD%3E%3CTD%3E%24999%2C999.99%3C%2FTD%3E%3CTD%3E1.01%25%3C%2FTD%3E%3CTD%3E1.46%25%3C%2FTD%3E%3CTD%3E1.91%25%3C%2FTD%3E%3CTD%3E2.36%25%3C%2FTD%3E%3CTD%3E2.76%25%3C%2FTD%3E%3CTD%3E3.11%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%241%2C000%2C000.00%3C%2FTD%3E%3CTD%3E%241%2C249%2C999.99%3C%2FTD%3E%3CTD%3E1.02%25%3C%2FTD%3E%3CTD%3E1.47%25%3C%2FTD%3E%3CTD%3E1.92%25%3C%2FTD%3E%3CTD%3E2.37%25%3C%2FTD%3E%3CTD%3E2.77%25%3C%2FTD%3E%3CTD%3E3.12%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%241%2C250%2C000.00%3C%2FTD%3E%3CTD%3E%241%2C499%2C999.99%3C%2FTD%3E%3CTD%3E1.03%25%3C%2FTD%3E%3CTD%3E1.48%25%3C%2FTD%3E%3CTD%3E1.93%25%3C%2FTD%3E%3CTD%3E2.38%25%3C%2FTD%3E%3CTD%3E2.78%25%3C%2FTD%3E%3CTD%3E3.13%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%241%2C500%2C000.00%3C%2FTD%3E%3CTD%3E%241%2C749%2C999.99%3C%2FTD%3E%3CTD%3E1.04%25%3C%2FTD%3E%3CTD%3E1.49%25%3C%2FTD%3E%3CTD%3E1.94%25%3C%2FTD%3E%3CTD%3E2.39%25%3C%2FTD%3E%3CTD%3E2.79%25%3C%2FTD%3E%3CTD%3E3.14%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%241%2C750%2C000.00%3C%2FTD%3E%3CTD%3E%241%2C999%2C999.99%3C%2FTD%3E%3CTD%3E1.05%25%3C%2FTD%3E%3CTD%3E1.50%25%3C%2FTD%3E%3CTD%3E1.95%25%3C%2FTD%3E%3CTD%3E2.40%25%3C%2FTD%3E%3CTD%3E2.80%25%3C%2FTD%3E%3CTD%3E3.15%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%242%2C000%2C000.00%3C%2FTD%3E%3CTD%3E%242%2C499%2C999.99%3C%2FTD%3E%3CTD%3E1.06%25%3C%2FTD%3E%3CTD%3E1.51%25%3C%2FTD%3E%3CTD%3E1.96%25%3C%2FTD%3E%3CTD%3E2.41%25%3C%2FTD%3E%3CTD%3E2.81%25%3C%2FTD%3E%3CTD%3E3.16%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%242%2C500%2C000.00%3C%2FTD%3E%3CTD%3E%242%2C999%2C999.99%3C%2FTD%3E%3CTD%3E1.07%25%3C%2FTD%3E%3CTD%3E1.52%25%3C%2FTD%3E%3CTD%3E1.97%25%3C%2FTD%3E%3CTD%3E2.42%25%3C%2FTD%3E%3CTD%3E2.82%25%3C%2FTD%3E%3CTD%3E3.17%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%243%2C000%2C000.00%3C%2FTD%3E%3CTD%3E%243%2C499%2C999.99%3C%2FTD%3E%3CTD%3E1.08%25%3C%2FTD%3E%3CTD%3E1.53%25%3C%2FTD%3E%3CTD%3E1.98%25%3C%2FTD%3E%3CTD%3E2.43%25%3C%2FTD%3E%3CTD%3E2.83%25%3C%2FTD%3E%3CTD%3E3.18%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%243%2C500%2C000.00%3C%2FTD%3E%3CTD%3E%243%2C999%2C999.99%3C%2FTD%3E%3CTD%3E1.09%25%3C%2FTD%3E%3CTD%3E1.54%25%3C%2FTD%3E%3CTD%3E1.99%25%3C%2FTD%3E%3CTD%3E2.44%25%3C%2FTD%3E%3CTD%3E2.84%25%3C%2FTD%3E%3CTD%3E3.19%25%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1263393%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3F%3F%3F%20HELP!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1263393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599982%22%20target%3D%22_blank%22%3E%40Rick_Miller%3C%2FA%3E%26nbsp%3BA%20combination%20of%20INDEX%20and%20MATCH%20would%20do%20the%20trick.%20Please%20see%20the%20attached%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264958%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3F%3F%3F%20HELP!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264958%22%20slang%3D%22en-US%22%3E%3CP%3ETHANKS!!!!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1264961%22%20slang%3D%22en-US%22%3ERe%3A%20vlookup%3F%3F%3F%20HELP!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1264961%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F599982%22%20target%3D%22_blank%22%3E%40Rick_Miller%3C%2FA%3E%26nbsp%3BWELCOME!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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

 

 

 

 

Highlighted

THANKS!!!!@Riny_van_Eekelen 

Highlighted

@Rick_Miller WELCOME!!