Multiple Data Validations based on an IF ?

[Taryn]

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?

 

[ETAF]

how about
=IF(B5=C5,H1:H10,IF(B5=C6,I1:I10,IF(B5=C7,J1:J10,K1:K10)))
in data validation
But what is in the ELSE ?
I have used range K1:K10 and so will be blank

see E5

 

[Taryn]

Ahhh amazing thank you!

 

[ETAF]

you are welcome