Hi, We have two sets of data in Excel that we need to match up and combine when they match. Spreadsheet 1 has two columns, A is a S/N and B is the page count. Spreadsheet 2 also has two columns, A is the S/N and column B is an ID number. We need to match the S/N from spreadsheet 1 with spreadsheet 2, and if there is a match, add the ID number from spreadsheet 2, column B in to spreadsheet 1, column C. Is this something easily done without VB knowledge? Thank you, Steve
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!