Data Validation

  • Thread starter Thread starter RE: VLOOKUP fORMULA
  • Start date 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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
pulling data 3
Changing the Status of Cell 1
pulling from one sheet to another 3
Text to dates 6
Sort using formula 15
SUMIF, use List as a Range 2
Wrong data type 2

Back
Top