Can you give us a little more information?
If you have a vlookup in cell B1 and the first part of the vlookup formula
is looking at A1. If you click on A1 and go to Format-Cells-Protection tab
and uncheck locked. Then go to Tools-Protection-Protect Sheet, you will be
able to change A1. If you change A1, the result in B1 will change as well (if
the result of the vlookup formula is supposed to change).

"Glenn" wrote:

I have set up a cell to pull infromation via vlookup. It work fine. My
problem is i want to be aboe to change the results of that cell without
loosing the formular for that cell. When i porotect the worksheet it will
not let me do anything with that cell.