Hide "#N/A" in Vlookup cell when data val list is not populated

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

Try the IFERROR function

=IFERROR(VLOOKUP(....),"")

Or you could just check for your data val cell being empty:

=IF(cell="","",VLOOKUP( ... etc

Hope this helps.

Pete

Cool....I'll give it a pop!

Cheers lads, Much apreciated