The first in the Purple Crown Series on creating an online order form in Excel 2021. In this video you will learn how to create a dynamic sortable dependent dropdown list for your merchandise using the XLOOKUP, UNIQUE and SORT dynamic array functions. Also, how to use Excel 365 to make it searchable.