Validation source on another worksheet

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Can I make a drop down menu and list by using the source
from another sheet. If so how?
Also will the INDIRECT function and VLOOKUP work from
another worksheet?
 
Yes , Yes and yes. For the validation, name the range on the other sheet, and then when you get
the option to go select a validation list, type in =your_rangename
 
Back
Top