I have a spreadsheet that what i am trying to accomplish is that when an address is typed into a column it will look up and match the town and will come back with the county it is in. I have two pages Master and Town & City. Master contains the address (B) and county (C) column. Town & City has the table that contains a list of towns and cities (A) and the corresponding county (B). I have tried various if then statements and lookups and can't quite seem to get it. Any help would be amazing.