Combining Data

C

chaddsines

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
 
F

Farhad

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
 
Top