I have a spreadsheet where I want to display the option for a validation list; but only if there is text in the adjointing cell. The text and location of the text shifts when selecting different industries. So, in the sample file, If text is evident in Cell B7, than the Validation Option should show up in Cell A7. The validation should also show up in Cell A14 and A20 (although I didn't put it in as a sample). The same would happen in Cells C and D, again if there is text in cell D, than the validation option would present itself in the corresponding cell in column C.