compare data from different worksheets and return matching results
 

I have two worksheets with data that I want to include on one
worksheet. Both worksheets have a common link (part number).

Worksheet 1 has the part number, some inventory codes and orders
dates.
Worksheet 2 has the part number, description and location.

Is there a formula that will compare the part number from worksheet 1
with the all the part numbers from worksheet 2, and if they match
return the part number (from either worksheet) description (from
worksheet 2) and location (from worksheet 2) and order date (from
worksheet 1).

Thanks for any suggestions.

Sean

compare data from different worksheets and return matching results
 

Sean,

Take a look at VLOOKUP.
Here's a good resource. http://www.contextures.com/xlFunctions02.html

Best regards,
Dave


"spmu" wrote in message
...
I have two worksheets with data that I want to include on one
worksheet. Both worksheets have a common link (part number).

Worksheet 1 has the part number, some inventory codes and orders
dates.
Worksheet 2 has the part number, description and location.

Is there a formula that will compare the part number from worksheet 1
with the all the part numbers from worksheet 2, and if they match
return the part number (from either worksheet) description (from
worksheet 2) and location (from worksheet 2) and order date (from
worksheet 1).

Thanks for any suggestions.

Sean