Matching data in Excel
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
Software/Hardware used:
Excel 2007
Software/Hardware used:
Excel 2007
ASKED:
September 27, 2010 8:15 PM
UPDATED:
September 28, 2010 4:16 PM
Answer Wiki:
Try using the vlookup command.
In column c of spreadsheet 1 add the vlookup command and if it is found in column 1 of spreadsheet 2 it will copy content of cell in column 2 over to sheet 1.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
