Matching Data from 2 worksheets into One

[WiseInTraining]

First off, I'm using Excel 2003 at work.

I am building a production worksheet to help our manufacturing shop to know when a part is completed in the laser dept and ready for the press dept to press the part.
As of right now, each department has their own seperate spreadsheet that contains a lot of information, and I would like to tie these two together somehow.
They each contain the part numbers so that is the common ground/column, however they are not in the same order so I cannot do a simple click and drag to have them match up.

Column A is part number, Column B is due date, and Column C is part description. This is the same for both worksheets. The Laser worksheet does not have the description fields completed. I would like to write a formula to have the Laser worksheet match the Press worksheet by the part number and automatically fill in the matching part description.

Thank you for your help - I cannot figure out how to attach the workbook on here to show you, so if you'd like to see it for yourself, I can email it to you for help! This is my 1st time posting on here

-M

 

[montecarlo2079]

you can solve this with a vlookup

=vlookup(part number, other sheet name/location$A:$C,3,false)

Copy this formula into column c of the sheet where this info is missing
this will automatically lookup the part number on this sheet, match it to the part number on the other sheet, and pull over a description if there is one.

 

[WiseInTraining]

Ok, that almost works. Do I need to replace the word "location" with something? I understand that I changed the word "other sheet" to Press.

Thanks so much!

 

[montecarlo2079]

the easiest way is to open both the spreadsheets. start typing the formula in the one you need, when you have it lookup the other sheet, manually click the range and it should add the location in for you.

I used it as a placeholder so you can see how the formula should be written

 

[WiseInTraining]

Ok, thanks. I am getting somewhere with it, and I'm researching a lot. I also have run into the problem where the 1st worksheet contains some letters after the part# and the 2nd worksheet does not have letters. It is not always the same amount of letters so doing a straight LEN formula does not work. If you have any suggestions on how to remove x-amount of letters after a number, I'd appreciate that too. If you don't, then thank you so much for your help already! It's nice to know that strangers like helping strangers