Excel Forum

Excel Magic Trick 295: DV Dropdown From Diff Workbook

See how to create a data validation dropdown list in 1st workbook when source list is in 2nd workbook. See the IF function with workbook cell references. See the OFFSET function used to define a dynamic range using a named formula. See the COUNTIF and COUNT functions used to count words and numbers.

Data validation drop down list.

Video made for Genevieve Atkinson.

Got a Question? Ask it Here in the Forum.