Hello,

I'm hoping someone can point me in the right direction. I'm using Excel 2010. I have two excel Worksheets with the following types of data:

Worksheet 1:
Computer Name
Work Area
Operating System

Worksheet 2:
Computer Name
Software Version

Some computers would have multiple versions of a software installed so Worksheet 2 would have some computer names listed more than once.

I am trying to create third worksheet where for every Computer Name on Worksheet 2 the Software Version, Work Area and Operating System is written out. This would mean I need to lookup the Computer Name from Worksheet 1 to get the Work Area and Operating System.

I've searched the net looking for how best to do this. The common answer I come across shows that the Computer Name from each worksheet match (no duplicates). In my scenario, I do have duplicate Computer Names due to multiple versions of the Software being installed.

How would I go about solving this problem? Please point me in the direction that would give me what I need.

Thank you.