Hi
I am new to this forum so Hello from England
I have used Excel for many years and would say that I was an intimediate user. I teach myself by following many youtube videos.
My sister asked me to create a Pricing worksheet for her but I cannot figure out the drop down issue
If I have one table with all the items in and prices I am ok but when it comes to 2 lists i have got stuck and cannot figure it out.
(Sorry if rambling...i have adult autism and struggle to find right wording)
I have a basic pricing sheet and 2 tabs with different items and their price.
On the Pricing tab in the first colum i have a simple data validation list where you select F (Flowers) or S (Sundries) and what I want is if i select F then in the next column a list of all the items from the flowers tab and if I select S then all the Sundries listed.
I do have named ranges etc
I am not sure if I can have 2 different validation lists for the same column
Have attached a copy for anyone to have a look. Have had to shorten the lists as file was too big to attach
Thank you in advance
Dave
Hi Dave,
You didn't mention which Excel version you are using. The attached file contains two possible solutions. One that uses dynamic array functions like FILTER and XLOOKUP that only work in Excel for MS365 and Excel2021. The other will work in all Excel versions, but is less dynamic.
Note that I created one price list with a code column for F or S, rather than having separate tables for each product group. Then I also created a separate tab for the Data Validation lists.
See which one one works for you. Come back here if you get stuck!
Best,
Riny
Hi Riny
Thank you for the reply. I realised after I posted i forgot which version of Excel...Im using Excel 365
Thank you for your solution and I will have a look and definitely get back to you
Dave
