Dear friends,

I've got a column with addresses as a text string. Text may contain name of a street, city, house number etc. Besides there is no strict order that name of street should come first, it can be anywhere in a text string. Another table contains two columns: first one with keywords (street name as a keyword) and second column contains relevant postal code. I need to check if any keywords from second table is present in each cell of column with addresses, if yes then return name of street (keyword) or postal code relevant to this keyword. I'll be very grateful for your help! Regards, JekaterinaExample.xls