1 Attachment(s)
Data Validation - Multiple Criteria
Hey everyone.
I am setting up a spreadsheet to try and force users to stop submitting it with missing information. I've set up a custom validation on many of the cells that will not allow data entry unless they put something in the preceding cell
=OFFSET(J3,0,-1)<>"" which works great until i come to a cell that already uses a list.
I've Googled and think i should be using If(AND... to get multiple criteria to work but just keep getting a formula error message. In the example above the Cell J3 also uses the named range YN to generate a drop down list so i need to combine the existing drop down list with the offset formula above but really stuck.
Could anyone help or tell me where I'm going wrong please?
Thank you
MykalAttachment 13422