Create data validation list

[KriZo]

I would like to create a list in a cell where i can choose form a list of values in a given range. From this range, several references can be found, and i need to cross these to an original ref.

I have attached and example sheet, where it is easier to understand what i am going at i think.

[Rui Farinha]

This is a very helpful tutorial that explains step-by-step what you need better than I ever could by my own words:

http://www.contextures.com/xlDataVal02.html

Hope it helps.

[FDibbins]

So what would your sample answer/s look like, and where with it/they go?

[KriZo]

So what would your sample answer/s look like, and where with it/they go?

This is what i hope to achive. Lets say i want to be able to choose from the OE suppliers for Apples. I want a list where i can choose all the OE's, if i then choose supplier G i want C2 to return all the OE ref values in column G related to Apples and supplier G.

Final.PNG

[AliGW]

Did you look at the tutorial linked to in post#2? It does exactly what you want.