Compare and Combine two lists

[WhiteZephyr]

Good Afternoon,

I have two worksheets in excel.

One is an order list.

Order# || Product
12345678 || Blue Mug
23456789 || Green Mug

The other is an efficiency list of time it takes to build each product.

Product || Assembly || Paint || Labeling
Blue Mug || 1:20 || 2:10 || 3:00
Green Mug || 1:30 || 1:40 || 2:00

What I'd like to do is take the order list, compare it to the product list, and then add the time it takes to build each product in a new column under new headings for each order.

Order# || Product || Assembly || Paint || Labeling
12345678 || Blue Mug || 1:20 || 2:10 || 3:00
23456789 || Green Mug || 1:30 || 1:40 || 2:00

Consider there are roughly 400 orders on the list, and around 30 different products. Rather than hard coding a bunch of nested IfThen statements or SelectCase, is there a better, more efficient way to do it?

Any help would be greatly appreciated!

[Bjornar]

You should check out the VLOOKUP formula. That's what you need. Use Excels helpfile, or search this forum. There should be thousands of exampels here.