Hi, 

want to create auto sugest & auto pop up data validation list same as google sheet, without Macro & VB in Office 365.

Please check attached image below. i want ot do same in Excel, if i type any word in that Location Column then it should automatically pop up, 
for Ex, if i Type Mech then all the Mech Options should autosuggest & autopop up in Excel. this thing is easily available in google Sheets but want to creat in Excel without using Macro or VB.

Thanks.