Excel Formula Needed For Matching data from two worksheets 1

[bamundsen]

Hello all:

I have two worksheets that contain product data. The first worksheet contains data extracted from my database. The second worksheet contains data from our vendor's database. There is only one record on both worksheets that is the same, which is the prodID. Only problem is there are part numbers on the vendor's worksheet that we do not need. So if I sort the vendor's data by prodID, and match them with my data, it don't match up. I need the ability to say... take the partID from the vendor worksheet, look for a matching partID on my worksheet. If there is a matching partID, then add the corresponding price value from the vendor worksheet to my worksheet. Make sense?? I am having all sorts of problems getting this to work. Any help woudl be much appreciated. Thanks,

Brett

 

[JICDB]

Have you tried a look up table? Essentially what a look up table does is say "match this record with the product ID on the vendors worksheet and return to me the value in colum X (price value)". Search the function list for Vlookup (vertical lookup) and it should walk you through it.

 

[jdhilljr]

Use vlookup.

http://www.hughes-brothers.com/testing.xls

Here's a sample.

Jim