Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 12, 11:39 PM
Junior Member
 
First recorded activity by ExcelBanter: Aug 2012
Posts: 1
Default Equipment log

Hello

I am trying to create a register/log of equipment for our office. I have the data in a s/sheet and not sure what formula I need to use. Each piece of equipment has an ID, serial number, description and service date. I want to create a log where my engineers can just enter the ID reference in one cell and it pulls the serial number, description and service date into the cells going across. I am guessing I will need some sort of look up table. any ideas please?

  #2   Report Post  
Old August 4th 12, 09:01 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2010
Posts: 143
Default Equipment log

There are at least two options:

1. AutoFilter - this presents the user with a pull-down list. All the user has to do is check the desired ID and the other associated daa will be displayed.

2. VLOOKUP() formulas also allow the user to enter an ID and have the assoicated data displayed.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
rental equipment invoice deholmes Excel Discussion (Misc queries) 1 May 27th 10 11:31 PM
equipment service tracking Ongoing Equipment Service Detail-Date/BR Excel Programming 1 August 22nd 07 01:14 PM
Equipment checkout calendar joannelj Excel Worksheet Functions 3 March 13th 07 06:44 PM
Need Help: Determine Equipment Capacity Will[_12_] Excel Programming 5 February 21st 07 06:09 PM
looking for equipment maintainance log highgear18 Excel Discussion (Misc queries) 1 November 24th 06 07:02 PM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017