VLOOKUP formula gives me an error if the source cell is empty

I am making a spreadsheet to do lighting audits....in column A, I have a drop down list of different light fixtures.....select a specific light and the other columns populate according to the vlookup reference, i.e. cost, watts, etc.
I have about 15 rows for listing the lighting and its corresponding specs. If there is nothing selected in Column A (row 12), the values in Columns B,C,D are all giving me the #N/A error. I want Columns B,C,D to be blank unless I select a lighting fixture in Column A.

Thanks for any help.

Use IFERROR.

Eg, this is not specific to your formula but an example of IFERROR used,

=IFERROR(VLOOKUP(B1,C1:D13,2,FALSE),"")

If you can't work this into your formula, post it up.

Or

=IF($A12="","",your VLOOKUP())

Figured it out!! THANK YOU!!

I had to change the formatting to text or number where appropriate - I kept getting errors, but got through it thanks to you.