Validation List Headache (List based on cell entry)

[garypea123]

Good Afternoon,

I am sure its an easy one but its giving me a headache,

What I am looking for is the validation list command (in C3) which will look at Cell B3 and then give me a list for E:G.

Based on Gary the field should be Cheese / *******s.

 

[awoohaw]

One option is to have put in array formula in cell H2 or I2 filtering your list by the name, and refer to that cell in the validation list rule.

Book1
	B	C	D	E	F	G	H	I	J
1
2	Name	Field		Gary	John	Phillip		Filtered List
3	Phillip			Cheese	Lager	Games		Games
4				*******s	Wine	Books		Books
5
6
Sheet4

Cell Formulas
Range	Formula
I3:I4	I3	=FILTER($E$3:$G$4,B3=E2:G2,"")
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
B3	List	=$E$2:$G$2
C3	List	=$I$3#

 

[garypea123]

Yes - I was thinking about this (and I should have been clearer).

However, in column C there will be multiple rows. C3 down to potentially C2000. So it down not work to create a filter list for each and every line.

It is more like the below. Obviously this is very simple version of what I am trying to achieve

 

[awoohaw]

Take a look at this youtube video:

 

[garypea123]

Excellent - Very good video and extremely clear.

All my lists are now set up and working perfectly with a lot of extra knowledge taken in.

Thank you very much for sharing this video

 

[awoohaw]

My pleasure, Happy to help.
Best wishes!