Equipment log

B

busyizzy

Hello

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

James Ravenswood

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Create table using periodical located text from multiple pages 0
Query to return latest dates 5
Copy previous record into form field 0
Need a formula for a Marketing equipment log 1
Conditional Appearance of Form Sections Based on Option/Radio Selections 1
Left Join issues 1
Tables 1

Top