You can choose custom and then use a formula to compare against two lists.

=OR(Countif(Room!$A$2:$A$21,A1)0,Countif($C$2:$C$ 21,A1)0) where A1 is the
cell wher you are putting the validation

" VLOOKUP fORMULA" wrote:

Dear All,

In data validation rule Is there any way to apply two range?

=Room!$A$2:$A$21, $C$2:$C$21