Filter a table to give the rows to data validation

[danbenedek]

I have a range with 2 columns
1 a
1 b
3 c
3 d
2 e
2 f
In a cell I want to have data validation for example all the values from column 2 from the above range where the first column is 3.

How can I do that?

[wenqq3]

I read many times, but i still don't understand your question.

[danbenedek]

So in column A i have the values
1
1
3
3
2
2
In column B
a
b
c
d
e
f
In cell C2 I want to have a datavalidation with the values from column B where the value from column A is 3.

[wenqq3]

Sorry for my poor understanding. Maybe you can give example, how is the result for cell C2. Thanks
I hope other who understand your question can help you.

remark:Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell.

[Tony Valko]

A couple of questions...

What version of Excel are you using?

Is the data sorted or grouped together in the first column as your sample demonstrates?