Advanced Microsoft Excel question?

Ok so I have 2 worksheets. Worksheet 1 has 4 columns; length, diameter, year, material Worksheet 2 has 5 columns; length, diameter, year, material, and object ID I want to know if there is a way to take a row from worksheet 1, so 1 value for each category, and take those values and compare it to every row in... show more Ok so I have 2 worksheets.

Worksheet 1 has 4 columns; length, diameter, year, material

Worksheet 2 has 5 columns; length, diameter, year, material, and object ID

I want to know if there is a way to take a row from worksheet 1, so 1 value for each category, and take those values and compare it to every row in worksheet 2 to see if rtbere is a march. If there is then have excel display the object ID of the match it corresponds to.

Anyone know how to do this?
5 answers 5