Excel 2016 – 3.7.6 – Create a Drop-down Menu for the Lookup Value

Now that we’re comfortable with the VLOOKUP function, we’re going to make our Invoice sheet more dynamic by creating drop-down menus that we can pick values from, rather than typing them in.