Lookup table for picklist

Topic

New Reply

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.

Reply | Quote

Replies

Hi

Not sure exactly what you are doing, but I have an example file attached which might help you.

It uses a Form to allow the User to make a selection, and places the Ingredient Code in column A as requested.

Please let me know if this helps.

If it doesn’t, let me know anyway.

I can explain what I did.

zeddy

Carpe Diem

Fish-Of-The-Day

Reply | Quote