Hi all,

I wanted to make the data validation option to display a list of items( "projects" in my case), for the rows which match with the numerical value 1. Please keep my attached file open for better understanding. As per example in it,

There are projects named project1,2,3,4,5 & 6 under input side, which I must be able to display them on a list using data validation such that the projects entered with 1 on the month column must be displayed on the output list. Hope you get it.. Help on this.

Thanks in advance..Data Validation.xlsx