Hi Folks,

I cant seem to work this out

I have cells that vlookup populates by looking up data from a data val drop down list. This works great, but when there is no data selected in the drop down list the vlookup cell/s display #N/A. I have tried to use conditional formatting hide it by colouring the text but this doesn't work.

Any ideas?

Kind Regards
Carl