Lookup table for multi-column picklist / validation

bdesilva

New Member
Joined
Dec 13, 2006
Messages
7
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.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

mamady

Board Regular
Joined
Sep 23, 2011
Messages
160
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Dec 13, 2006
Messages
7
Office 2016. Current version in Office365 desktop.
I haven't built it yet. My design is above.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,935
Messages
5,545,101
Members
410,656
Latest member
Hydraulics
Top