Combine two spreadsheets based on matching column (2002)

Topic

New Reply

I need to copy data from one spreadsheet and paste it in another based on a matching column. I need the

Reply | Quote

Replies

Second file

Reply | Quote

You can use VLOOKUP:
– Open both workbooks.
– Activate the Domain Users workbook.
– In B2, enter the formula

=VLOOKUP(A2,'[Last Logon.xls]last logon'!$A$1:$B$7,2,FALSE)

– Fill down to B6.

Reply | Quote

Thank you, Hans. That does the trick!

Reply | Quote