I have a spreadsheet with two columns of data: A1 - School & B1 - Code. In cell A2 I use a validation list drop down menu which uses data from another sheet tab to select which school I want. In cell B2, I use VLOOKUP to auto-populate data. Here is the formula I use for B2: =VLOOKUP(A2,School:Code,2). The problem I have is that when I first open up the spreadsheet, and I haven't selected a school from the drop down menu in A2, cell B2 has #N/A in it. Is there a way around this so that cell B2 remains empty until I select a school for A2? Thanks in advance.