C
chief
I tried to protect certain cells which have codes in them so that th
user only uses the drop down list in order to filter that informatio
into the other cells. My concern is that a user might enter info into
cell that has those =IF(....) codes in the cell, and will thereb
eliminate its use of the code. It doesn't seem to work though. Is ther
a way I can have it so that the VLOOKUP coded cell will be protecte
from outside manual input, yet still function when the user clicks o
an item from the dropdown list?
thank
user only uses the drop down list in order to filter that informatio
into the other cells. My concern is that a user might enter info into
cell that has those =IF(....) codes in the cell, and will thereb
eliminate its use of the code. It doesn't seem to work though. Is ther
a way I can have it so that the VLOOKUP coded cell will be protecte
from outside manual input, yet still function when the user clicks o
an item from the dropdown list?
thank