Excel Question about linking workbooks

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am having a hard time figuring out how to link workbooks. I would like to have a main workbook that we number with a job number and a row of data like name, company, etc...

The second workbook would be a work order sheet and when I type the job number from the first workbook then the data from that row will auto-fill into the work order.

Like this:

Job Numbers.xls:

10-066 Joe Smith RMG Corp. 253-665-2342 etc...

10-067 Phil McCracken ABC Inc. 235-334-6543 etc...


Work Order.xls:


Job Number -- 10-066

Company -- Joe Smith

Name -- RMG Corp.



Is there anyway that I can do this with Excel??

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Have you tired VLOOKUP

some thing like this


=VLOOKUP(A1,'C:\Users\haadi\Desktop\[Job Numbers.xls]Sheet1'!$A:$D,2,FALSE)