What I want to achieve:
select list A, B or C from a dropdown, when pressed, list of values displays underneath. I would also like the list to be populated from items in a table (which would have many duplicates, which I wouldn't want included multiple times)
I hope this makes sense! in summary, I want a dropdown menu to display different cells from a table - this will be similar to a vlookup, but it will need to display multiple cells (ie. an item name, department code, and cost code)
I'm hoping this is achievable without using VB as I want normal uses to be able to add or remove items if they choose to