LookUp
On my project, I used VLOOKUP to count the regular employees on sheet 1,
so that on the sheet 2, it display how many regular employees does company have..
Now, I want to lock the cell on the sheet 2, so that it didn't update everytime I add new regular employees.
Example, on day 1 there's 200 employee, and the result on sheet 2 is 200 also. . on day 3 the employees become 215, and I want that the result on sheet 2 is fixed.
Anyone help me. . please. . .
|