Hi Rob,

Is each address a single string or is it broken down into discrete
fields? E.g. Street, Town, County, Post Code.

If the latter, you will probably be able to accomplish what you need
using VLOOKUP. Otherwise you will need to parse the strings first to
get some matching fields between the two spreadsheets.

Nick