Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download workbook: http://people.highline.edu/mgirvin/Ex...
See how to:
1. Select From Drop Down and Pull Data From Different Sheets using Data Validation List, the INDIRECT Function, and the join symbol ampersand &
2. Learn about syntax for Sheet References
3. INDIRECT Function
4. Data Validation Drop Down List
