You will learn two different methods to accomplish this task.
PRACTICAL FILE
Download the sample file used in the video.
https://docs.google.com/spreadsheets/d/1R1dThPIAPJjG2Z9ZMO6nPZdLlNVdCRXcoJ4lollhiVk/copy
RESOURCES
– Free spreadsheet templates: https://spreadsheetlife.com/free-templates/
– The Spreadsheet Life blog: https://spreadsheetlife.com/blog/
LEARN EXCEL OR GOOGLE SHEETS
– Excel Total Course: https://spreadsheetlife.com/excel-total-course/
– Google Sheets Masterclass: coming soon…
VIDEO CHAPTERS
00:00 – Introduction
00:16 – Configuration of Ex 1
00:49 – Ex 1 drop-down list
01:44 – Formulas Ex 1
02:59 – Configuration of Ex 2
03:23 – Ex 2 drop-down list
03:51 – Formula Ex 2
04:45 – Conclusion
05:07 – Exit
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments