Hi All,
I'm new here, so i will try to be as clear as possible:
I have a column which contains a full address i.e.
285 Charlemont, Griffith Avenue, Dublin 9
262 Larkhill Road, Whitehall, Dublin 9
I have a lookup table that contains
(A1)Estate (A2) delivery day
(B1)Charlemont (B2)Tuesday
(C1)Larkhill Road (B3)Wednesday
How can I add a new column beside the full address that will contain the relevant delivery day?
Please note that changing text to column and doing a vlookup doesn't work because some estates have 2 or more words.
Thanks for help in advance
K
Bookmarks