Home

Lookup w/Identical Data in Multiple Rows (of first column)

%3CLINGO-SUB%20id%3D%22lingo-sub-478469%22%20slang%3D%22en-US%22%3ELookup%20w%2FIdentical%20Data%20in%20Multiple%20Rows%20(of%20first%20column)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-478469%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20build%20a%20workbook%20that%20will%20allow%20be%20to%20enter%20a%20value%20in%20one%20sheet%2C%20and%20then%20have%20formulas%20use%20that%20value%20to%20lookup%20associated%20values%20with%20the%20originally%20entered%20value%20from%20a%20separate%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20working%20on%20a%20meal%20planner%20tool%2C%20so%20will%20use%20this%20as%20example%20data%20for%26nbsp%3B%20your%20review%20(though%2C%20I%20have%20certainly%20run%20into%20this%20previously%2C%20which%20is%20why%20I%20am%20pinging%20the%20community%20for%20help%20now%20%3A-)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20please%20consider%20a%20starting%20data%20set%20something%20like%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109755i30A4809BC483BFC2%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22starting%20data.JPG%22%20title%3D%22starting%20data.JPG%22%20%2F%3E%3C%2FSPAN%3E%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20be%20on%20another%20sheet%20and%20choose%20from%20a%20drop%20down%20list%20(I%20know%20how%20to%20use%20data%20validation%20for%20this)%20the%20'Meal'%20-%20then%20I%20would%20like%20the%20other%20sheet%20to%20populate%20the%20ingredients%20needed%20based%20on%20this%20starting%20data%20set.%20I%20have%20been%20trying%20to%20use%20combinations%20of%20VLOOKUP%2C%20INDEX%2C%20MATCH%20and%20tinkered%20with%20Pivot%20Tables%20a%20bit%2C%20but%2C%20cannot%20get%20it.%20The%20issue%20I%20have%20been%20running%20into%20is%20that%20in%20starting%20data%20set%2C%20the%20first%20column%20has%20many%20entries%20of%20the%20same%20value%20(as%20I%20have%20it%20currently%20organized).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%20of%20what%20I%20would%20like%20to%20achieve%20programaticaly%20is%20provided%20as%20an%20example%20below%2C%20where%20the%20'Meal'%20would%20be%20chosen%20for%20each%20day%20(red%20text)%20and%20then%20the%20ingredients%2C%20qty%2C%20and%20unit%20would%20auto-populate%20in%20respective%20locations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%200px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109756i298D95831510B484%2Fimage-size%2Fsmall%3Fv%3D1.0%26amp%3Bpx%3D200%22%20width%3D%220%22%20height%3D%220%22%20alt%3D%22daily%20meal.JPG%22%20title%3D%22daily%20meal.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109757iBFB0C17B5D203E05%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22daily%20meal.JPG%22%20title%3D%22daily%20meal.JPG%22%20%2F%3E%3C%2FSPAN%3E%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%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%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20ultimate%20goal%20is%20to%20be%20able%20to%20pick%20and%20choose%20meals%20for%20each%20day%20of%20the%20coming%20week%20and%20then%20have%20ingredient%20information%20populate%20-%20with%20all%20meals%20and%20ingredient%20info%20in%20a%20database%20sheet.%20Thanks%20in%20advance%20for%20any%20insight%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers!%20-JLS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-478469%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MtnRunOR
Occasional Visitor

Hi,

 

I am trying to build a workbook that will allow be to enter a value in one sheet, and then have formulas use that value to lookup associated values with the originally entered value from a separate sheet.

 

I am currently working on a meal planner tool, so will use this as example data for  your review (though, I have certainly run into this previously, which is why I am pinging the community for help now :-)

 

So, please consider a starting data set something like:

starting data.JPG

 

 

 

 

 

 

 

I want to be able to be on another sheet and choose from a drop down list (I know how to use data validation for this) the 'Meal' - then I would like the other sheet to populate the ingredients needed based on this starting data set. I have been trying to use combinations of VLOOKUP, INDEX, MATCH and tinkered with Pivot Tables a bit, but, cannot get it. The issue I have been running into is that in starting data set, the first column has many entries of the same value (as I have it currently organized).

 

An example of what I would like to achieve programaticaly is provided as an example below, where the 'Meal' would be chosen for each day (red text) and then the ingredients, qty, and unit would auto-populate in respective locations.

 

daily meal.JPG

daily meal.JPG

 

 

 

 

 

 

 

 

 

 

The ultimate goal is to be able to pick and choose meals for each day of the coming week and then have ingredient information populate - with all meals and ingredient info in a database sheet. Thanks in advance for any insight available.

 

Cheers! -JLS

1 Reply
Highlighted
Perhaps, I can help you achieve your goal if you attach your sample Excel file. I may also have to modify the layout of your data to suit your desired results.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies