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

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

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

On Sep 10, 8:47*am, MikeR-Oz
wrote:
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

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

Thanks Ken, worked well. Appreciated

"Ken Johnson" wrote:

On Sep 10, 8:47 am, MikeR-Oz
wrote:
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

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

On Sep 10, 11:32*pm, MikeR-Oz
wrote:
Thanks Ken, worked well. Appreciated

"Ken Johnson" wrote:
On Sep 10, 8:47 am, MikeR-Oz
wrote:
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

You're welcome.
Thanks for the feedback.

Ken Johnson