Lookup Field

L

Legacy 436357

Guest
Hello,

Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet? If so can that data be protected when the data is completed like in an invoice situation?

I appreciate any advice or help,
XJ
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
Is it possible to have a field on a worksheet that can serve as a lookup for an ID that I can pull the related data from another sheet?

Yes.

If so can that data be protected when the data is completed like in an invoice situation?

That data can be protected.

What do you mean by "...an invoice situation".

It's difficult to provide more specific advice as your request is pretty vague.
 
Upvote 0
Hi,

Thanks for the reply. I want to create an invoice workbook for service. I thought each invoice could have all of the information on a row in a table like Customer Info, parts, labor, etc. and pull that data from the ID or vice versa submit the data to that table on the other sheet.
 
Last edited by a moderator:
Upvote 0
I thought each invoice could have all of the information on a row in a table like Customer Info, parts, labor, etc. and pull that data from the ID or vice versa submit the data to that table on the other sheet.

Well, I imagine that probably could be done.

But for me, this is still all far too vague to provide more specific answers.

What exactly do you need help with ?
 
Upvote 0
For the ID I want it to be a lookup but also be able to put new ID. This is where I need the help please. Also to be able to lock that record with perhaps a macro?
 
Upvote 0
I have to leave for a little while now but will return with some more specific information thanks.
 
Upvote 0
Maybe like this?

Excel Workbook
ABCDEFGHI
1Closed
2
3AFR NumberSales OrderReceived Date
4
5Entered By
6
7Customer
8
9Description
10
11Part NumberOld Part Number
12
13Serial NumberOld Serial Number
14
15Customer ComplaintTest Equipment
16
17(TEL Number)
18
19
20
21Preliminary InspectionRepair Manual
22
2312A Spec
24
2591A Spec
26
27Progressive Inspection93A Spec
28
29Temperature?
30
31Humidity% RH
32
33PressureHg
34
35Repair DetailTechnician
36
37Repairman
38
39Disposition
40
41Finished Date
42
43Labor Hours
AFR Form
 
Upvote 0
The AFR number field will be the ID.
1: I want to be able to enter an AFR number and have all the fields filled from the table on the other sheet
2: Create a new AFR and fill in all of the info that gets stored on the table on the other sheet
3: Be able to lock that record and show it in the Closed field.

There will be more to do but these will get me started.

Thank you very much,
XJ
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,021
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top