I need to insert a property reference No. in a list of properties by
comparing with a second worksheet containing the reference No's. i think i
will need to match the first 2 or 3 lines of the address to do this.

Ref No | Address1 | Address2 | Address3
?????? | 15 | The Street | Our Town

i would appreciate any help with this as i need to import into Access using
ref no as unique ID
Any ideas?