Protecting/locking individual cells? + not displaying #N/A on cel

  • Thread starter Thread starter MikeR-Oz
  • Start date Start date
M

MikeR-Oz

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
 
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
Click to expand...

Select the cells that you want users to do stuff in then go Format|
Cells|Protection and deselect Locked option then OK.
Then go Tools|Protection...|Protect Sheet... OK (you can use a
password if you want. You can also experiment with the options.)


ALSO-

If column C is the column that the VLOOKUP is referring to then you
could use...

=IF(C1="","",Your VLOOKUP Formula here)


Ken Johnson
 
Thanks Ken, worked well. Appreciated

Ken Johnson said:
Select the cells that you want users to do stuff in then go Format|
Cells|Protection and deselect Locked option then OK.
Then go Tools|Protection...|Protect Sheet... OK (you can use a
password if you want. You can also experiment with the options.)


ALSO-

If column C is the column that the VLOOKUP is referring to then you
could use...

=IF(C1="","",Your VLOOKUP Formula here)


Ken Johnson
Click to expand...
 
Back
Top