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.
Bookmarks