IF cell gets deleted with new entry

[martin_br]

I have an allotment, we are handing out keys to other allotmentpeople for entry to the grounds.
I would like to make a sheet that automatically have the data in it ie the number of keys handed our.
I have made an IF formula that saves the number of keys handed out

in Column E i have =IF(F14=B3;E16;"") If the entrance in B3 (B is Column with all garden numbers 1-381 rows) = F14 (Single cell containing the garden number entered when the owner comes to get keys), then the value in F16 (manual entry of keys handed out is added in Column E). But when I enter a new value in F14 the number of keys from the previous entry(garden) dissapears.

Can someone please help me

 

[McGuilliam]

Is it possible to post your excelsheet, if needed with fake data? I'm not sure I completely understand your setup.

 

[martin_br]

Is it possible to post your excelsheet, if needed with fake data? I'm not sure I completely understand your setup.

 

[martin_br]

Is it possible to post your excelsheet, if needed with fake data? I'm not sure I completely understand your setup.

how do I upload it. My first time here, and I do not seem to be able to upload it.