Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-04-2011, 01:29 AM
aztiguen24 aztiguen24 is offline LookUp Windows XP LookUp Office 2003
Novice
LookUp
 
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
 

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 Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM
LookUp 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
LookUp Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft