Hi
I have this formula:
=VLOOKUP(F5,'Drop-down Info'!$A$4:$B$80,2,0)
It comes up with #N/A if there is nothing in F5
Is there a way to format the cell to be blank. I've tried a few different things but none have worked. If blank doesn't work a '-' would be good.
Thanks
Sandra
Bookmarks