filter a list based on cell value

[Allan_Smillie]

Good afternoon

I hope that you can help me.

I have a table called tblequip the column headers are

Site       Equip ID     Vib Value

Shell     77654         3.2

House   532             3

Shell      326t           1.5

I have used =unique  in a cell to give me unique Site values

The list that it created is used in data validation for cell G18

In cell F7, I currently have a data validation of a list where the values are taken from the Equip ID column.

What I want to achieve is when "Shell" is chosen in G18, F7 only presents "77654" and "326t" as available choices, as it has been filtered to Shell. How can I achieve this?

Any help is appreciated.

Allan

[#2 · Accepted solution]

@Allan_Smillie 

Hi there! See the attached workbook with my proposed solution.

It creates an auxiliary range with a simple FILTER() function, and then I take that range as a source for the data validation list.

Hope it works for as desired for you.

[#3]

@MAngosto
Thank you, this is exactly what I needed and I appreciate the time you took to create the file for me.

Cheers
Allan