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

[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

 

[Ken Johnson]

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

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

 

[MikeR-Oz]

Thanks Ken, worked well. Appreciated

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

 

[Ken Johnson]

Thanks Ken, worked well. Appreciated

You're welcome.
Thanks for the feedback.

Ken Johnson