Cell auto-populated by dropdown list shows error but I would like it blank

Good morning,

Cell I1 is auto-populated with the content selected in the dropdown list in A1.
When I choose the blank option in the drop down list, I1 shows an error message (#N/A).

However, what I would like is for I1 to also be blank/empty when the blank is selected in the dropdown list.

Any advice is appreciated; thanks.

Hi schroeder70,

You can use if statement. Please see: https://exceljet.net/formula/vlookup...rns%20a%20zero.

Hope this helps.

As above

=IF(A1=" ","",VLOOKUP(A1,'Sheet 2'!$A$2:$A$18,1,FALSE))

Hi
Try:
=IF(A1=" ";"";....

thanks; reps added.