Dynamic generation of list of values in a column based on values selected in another colum

[omsai.us]

Hi,

I am trying to populate a list of values suppose in columns B1, B2......Bn in sheet Values based on what I select in column A1, A2.......An. The values are given for different sets in the Data sheet. Suppose for name A possible values are x, y, z, similarly for name B possible values are s, t, u, v. In sheet Values I want the A columns as list of selection as well as B columns also as list of selection based on what I select in corresponding A columns. I would prefer simple use of IF-Else, Data Validation etc. rather than writing macro etc. Attached is the file for reference.

[FDibbins]

Try this in Values B1, copied down and across as needed...
=IF(A1="","",INDEX(Data!B:B,MATCH(Values!$A1,Data!$A:$A,0)))

[omsai.us]

Hi FDibbins,

This is not giving list in column B's rather it's simply returning a value. I want to clarify again that I want a list of values in column A's to select (which I can do), but based on value selected in column A's, list of values to select in column B's should be governed.

[samba_ravi]

Created some name manages and used data validation
see the attached file

[omsai.us]

Thanks nflsales for help. It solved my problem but a new problem is observed that after change in values seelcted in A's column, previously selected value in B's column is not getting cleared. I know I am asking for additional help but this was observed only after experimenting your suggestion. So, if you can help little more that will be great.