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
--
Farhad Hodjat


" wrote:

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