Hi All!
I have been trying to figure this out for almost the past month and have decided to again reach out to you guys with higher excel learning.
If you see the attached excel file starting with columns N and to the right, I have 2 different ways I am experimenting with data validation. The second way (row 3) I am having a bit of an issue trying to wrap my mind around. In Q4 I have set up the data validation to show a list of known concepts and made it so that a new concept can be typed in if need be. If a new concept is typed into Q4 I want the data validation in Z4 to reference the "other" concept in column F.
I have tried using if, iferror and iserror statements to achieve this. I feel as though I am close to what I am trying to accomplish and I am pretty sure this is still an "Excel General" Question.
Any and all help/pointers would be appreciated.
Thanks in advance!
Bookmarks