|You can add a blank choice by entering the final comma and then adding a space. BTW...you can also use a List from a range of cells instead of entering the list in the Data Validation dialog box. That way you could change the list and not have to update the Data Validation list for each cell that uses it. Adding a blank cell anywhere in that list will put a blank cell in your drop down.|
Add this to your mindset as you are creating a workbook:
If you find yourself doing the same thing over and over again in a number of cells, then Excel probably has a more efficient way of doing it. e.g. referencing a list in a single range of cells instead of typing that data over and over again in multiple locations.
When VLOOKUP doesn't find what it is looking for, it returns a #NA error. So we either need to tell the VLOOKUP function what to do with a blank cell or have the formula deal with the blank cell before it even gets to the VLOOKUP portion.
Add the bold portion to the front of your formula:
Don't forget to add the extra parenthesis at the end of the formula to close off the new one you added at the front.