Lookup table for multi-column picklist / validation

[bdesilva]

I’ve always used Data Validation to create a picklist from another table in my document. Works great. But what I’m trying to do this time I can’t get to work. I have a detail table that I want to grab data from another sheet. But I don’t want to just display one column. I’d like to display multiple columns to help the user pick the correct row to link. Any ideas?
Lookup Table
—————-
IngredientID
Ingredient
Detail Table
—————
ProductID
IngredientID
I’d like the IngredientID column in the detail table to provide a popup with both items from the Lookup Table, and when a row is chosen, the IngredientID to populate.

 

[mamady]

Hi Dear, can you please advise which office version are your using? this in order to recommend the most optimum way for you

It would help also if you can share your working or data set sample using XL2BB

XL2BB - Excel Range to BBCode

Thanks

 

[bdesilva]

Office 2016. Current version in Office365 desktop.
I haven't built it yet. My design is above.