HI,

My spreadsheet is using Vookup formulas and I would like to protect the
cells with the formulas from others changing them but still alow the oter
cells to be free . Such C1 free to place a number that will allow the
protected B1 (which has the look up formulae) to have the resulting detail
from the look up -locked/protected.

ALSO-

I have then copied the formulae down to the page and some cells will not
have all the time an item in them so now they are showing the #N/A - can this
be not displayed?

Ta
Mike