Thread: [Solved] LookUp
View Single Post
 
Old 05-04-2011, 01:29 AM
aztiguen24 aztiguen24 is offline Windows XP Office 2003
Novice
 
Join Date: May 2011
Posts: 2
aztiguen24 is on a distinguished road
Question 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. . .
Reply With Quote