Invoice address query

Thanx Dunc3142, I've got that bit sussed and defined all the columns it's the vlookup bit I'm struggling with.

I understand the "Vlookup(A1,Sheet2!" bit of NBVC's post, it's the bit after....

I assume the A1:B100 bit refers to the addresses range but not understanding the 2,FALSE bit

Keeps returning #N/A

Soz, just seen your new post.

I just worked that out but it's still showing a return of #N/A