Thanks for the reply it has worked for most scenarios. When I applied this to the full membership list I had some failures due to the state of the address data. What I am finding is that the vlookup is looking for exact text where what I need it to do is find the Location anywhere in the address 1 or address 2 field. eg if Location is Christchurch - Address line 1 is Cranfield Christchurch it will return Christchurch and not blank as at presnt.