Filtering validation lists in drop down boxes

Hi

I have a table with two columns:

a | 1
b | 2
c | 2
d | 2
e | 1


I want to create a dropdown box for data validation, where the values of the first column will be offered as validation.
This list should be able to be filtered. So for example, i want to show all values with the value 2 in the second column.
So the dropdown list should offer the values b,c,d

How can I do that?

Thanks in advance !

Hi Ganesh

thank you. That would do the required function but I actually have the problem, that the table contains several hundred of rows.
What I showed was an example.... The amout of rows is not fixed, so it will grow and therefore I need a generic solution, because
it would be too much work to specify each value.

I thought may be using the offset( and count() ) function but I am stuck how I could apply a filter within that construct....

Any ideas?

Thank you!