Conditional drop down list help

[Joebund]

Hi all,

This seems to be something fairly straightforward, but I cannot seem to find an answer, must not be using the correct key words.

Anyhow, I have two columns of data, column 'A' being employee name, 'B' being Y or N. I am trying to create a drop down list for all entries in column 'A', only if they have a 'Y' listing in column 'B'.

Can I do this within data validation, or do I need to address this another way?

Thanks!

 

[C Moore]

If you don't mind making another column, you could use this method to generate a list, How To Return Multiple Match Values in Excel Using INDEX-MATCH or VLOOKUP | eImagine Technology Group, where your lookup term is fixed instead of a cell reference (i.e. "Y" instead of the cell with "Mouse"). Create a dynamic list out of the new column, that would be the list for the data validation.