Alternative to Pivot Table stuff formatting

[dougiefft]

Hi all,

I currently display information in a Pivot Table type format. I have attached an example image of what I mean by the format (Img01).

I have another sheet which uses a table containing several columns of data. In each column, it is not uncommon for this data to have duplicate values in different rows (as displayed in Img02).

I need to be able to have a value in A1 of a worksheet. This will be a dropdown, containing all venues (as is indicated in Img02 as a column label). Once I have selected X venue, this will then display column (A, B, C, D or any column I require) in a cell of my choice (for example, A2) of any rows that have the value of A1 in it. In essence, I can achieve this partially with the Pivot Table formatting, as shown in Img01, but I need to manually change the field settings in Column B of the Pivot, so I can display the different venues listed in Img02.

I am aware that, if I had a unique value, this could be used via an Index/Match formula, but unfortunately, a venue can be assigned to multiple courses, for which I need to display each one.

I really hope someone can help me here!

Many thanks all

Dougie