Script to check if a pc name is in a spreadsheet and copy over sw serial # if found.

Hello,

I am looking for a script that checks to see if a computer name exist in a spread (from a list of computers in another spreadsheet in one column and software serial # in the next column over) and if found, copies the corresponding software serial # to the pc found, in the next column over.

Let me give you some background:
* I was asked to collect all of the products of a particular software company through out or large organization, with pc name, logged in user, department name, etc.
* useing sccm I was able to do this and export to a spreadsheet.

* I was then asked to pull in the software serial # from each of the products of the software on each pc in our organization. Luckly, it was a registry key location. This I did with the help of another script.

* now I need to combine the reports together as shown above. This would have been easy with just a few software titles, bu with thousands..ahhh, no.

Any help would be greatly apreciated..Really!!