Taryn
New Member
I would like to be able to have something like the following
IF(B5=C5 then return Data validation list 1
IF(B5=C6 then return Data Validation list 2
IF(B5=C7 then return Data Validation list 3
else "")
But no idea if this is possible or how to go about it if it is, could anyone help please?
IF(B5=C5 then return Data validation list 1
IF(B5=C6 then return Data Validation list 2
IF(B5=C7 then return Data Validation list 3
else "")
But no idea if this is possible or how to go about it if it is, could anyone help please?