I am having an issue with getting multiple valid_if equations to work on my app. I have two sheets, sheet A is โContactsโ and Sheet B is โListsโ. I would like my users when adding a contact to be able to select S_Agronomist, C_Agronomist, and Roll from drop down menus. In my โContactsโ Columns using Valid If i am able to add Valid if = Lists[S_Agronomist]. And it works correctly. but when I add a second valid if on a different line, such as Valid if= Lists[C_Agronomist] the C_Agronomist row disappears from my forum.
My list data has a unique id column, then S_agronomist names, C_Agronomist names, Roll, etc. IF I make new sheets for each or these columns it works but why wont it work if they are in my one sheet titled Lists?
Thanks you so much for the help! Thomas
LinkedIn
Twitter
