Hi, I am stuck!
Here is what I am trying to do. I need to import 2 csv files as arrays and compare the data and generate a 3rd csv file. CSV 1 is an inventory with 2 columns serial number, and computer name. CSV 2 has only 1 column with computer names. I would like to generate a new csv 3 file based on the computer names in csv 2 that contains the matching serial number from csv1, if no match is found for that computer name then leave the serial number blank or say not found.
Can anyone help?