Data Validation

  • Thread starter RE: VLOOKUP fORMULA
  • Start date
R

RE: VLOOKUP fORMULA

Dear All,

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

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

joel

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
 
Top