Thread: cell formular
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
glenn glenn is offline
external usenet poster
 
Posts: 122
Default cell formular

I have setup a formular for a cell A24. This cell have the formular of
vlookup(c15,d25:e25,2). This returns the correct results in A24. My problem
is this:

I woulld like to be able to change the results in A24. Let say the resulet
in A24 is $500.00. I change A24 to $775. When I do this I loose the
originial vllok formulatr in A24. I have protected the sheet but then it
will not let me change the results in A24. Is there anyway to lock the
formular but change the results of A24 manually?