![]() |
|
#1
|
|||
|
|||
|
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. . . |
| Tags |
| vlookup |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
Lookup a value from non-sorted data
|
udea | Excel | 12 | 04-25-2011 04:34 AM |
Field Lookup - Confused
|
lawnG | Word Tables | 1 | 01-31-2011 03:50 PM |
| Creating Lookup in Excel | vikash kumar | Excel | 2 | 12-06-2010 06:50 AM |
Using the LOOKUP Command
|
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |