Linking a drop down from another Google Sheets - Excel Tips and Tricks

Discover how to linking a drop down from another Google Sheets. This is the formula featured in my video. Importing Dataset =IMPORTRANGE("1PzmaXl6D3FtH07fC_EOnXO8LJB7CYqyBc1_Z6gRC9Wc","Tutti_Frutti!A2:A5") Here are the steps to create a dropdown in Google Sheets Create Drop Down 1) Select column where drop down needs to be inserted 2) Insert ~ Dropdown 3) Criteria is "Dropdown (from a range)" 4) Specify range '604'!A5:A 5) Done 6) Close "Data Validation Rule" window #tips #excel #shorts #fyp