Data validation

[mattless1]

Hi all,

I have a data validation list. Lets say F1,F2,F3,F4 located in cell A5 all these have a list of products

Is it possible that the list associated with list number (F1 TO F4) populates in column B when I select the data validation number from the list

Any help with this would be greatly apricated.

Kind Regard,
Mattless

 

[Aryatect]

Hi, If I understand this right you are looking for a dependent list as in if I select Product1 only List of Product1 populates in the drop-down for column B. In this case below should work for you:

https://drive.google.com/open?id=1enmbKV1DdyhjYOfsnU6QYVkGsAlRDOTu

https://drive.google.com/open?id=1otCLjuJ9K0C4nG8OfRCiDvbeVCaPi4pG

https://drive.google.com/open?id=1hsnubPPCGGCOMQC9gcEv0IfMOmbhWDHe

https://drive.google.com/open?id=1_9PSq-rkU-muDa9qay7tHkNB8ZEohV4g

 

[mattless1]

Hi Aryatect,

thanks for the reply

that would work, but im looking to populate the whole list not just one of the items.

regards,
Mattless

 

[Skybluekid]

Hi all,

I have a data validation list. Lets say F1,F2,F3,F4 located in cell A5 all these have a list of products

Is it possible that the list associated with list number (F1 TO F4) populates in column B when I select the data validation number from the list

Any help with this would be greatly apricated.

Kind Regard,
Mattless

Would you be requiring Dependant Drop Lists?

 

[mattless1]

Hi
I have worked it out using the index and match formula that worked.

=INDEX(A5:C5,,MATCH($I$4,$A$4:$C$4,0))

many thanks.

 

[Aryatect]

Glad could help in some capacity