Combining Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two spreadsheets:
SPREADSHEET 1: Contains address and account number.
SPREADSHEET 2: Contains address and other misc. data.

not all of the account numbers will be used (to many in spreadsheet1
compared to spreadsheet 2) I need to somehow match addresses, and place the
account number from each address in spreadsheet 2. I have tried the index
and the matching commands, no luck.
Thanks
 
Bdid you try using VLOOKUP? if not you can use it of cours if the addresses
in two spreadsheet is exactly the same as follow:

Spreadsheet1 Spreadsheet2
A B A
B
1 an address an account# 1 an address
=vlookup(A1,spreadsheet1!A1: B??,2,false)

Hope it will work
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending Data from one spreadsheet to another 4
collate data Vlookup? 1
Combining databases 2
SUMIF using date ranges & referencing account numbers 1
Combine information from rows 6
merging spreadsheet data 1
comparing 2 excel spreadsheets 1
help with vlookup to merge two lists 8

Back
Top