Append Montly Stats

[rdirvngjr]

Need help automating a task. I have a worksheet that has machine names in Col A and then Monthly stats in columns B thru F. Each month I get a list of machine names with the monthly stats. Unfortunately, you can't simply cut-n-paste as some machines are taken out of service and new machines are added. Machine names are unique. Is there a way (trying vLookup but struggling) that will use the machine name from the monthly list, lookup that name in the worksheet and then add/append the stat data to the appropriate monthly column? Also, is there a way to determine if any new machines are in the monthly list that are not in the consolidated Col A list? Thanks

 

[rdirvngjr]

Hey folks. OK, got vLookup working to append monthly stat to correct server name, if server is in the list. So now need help trying to tell if any new server names are on the list for each month. Thoughts?