I have 2 spreadsheets. 1 contains a list of customers with full post code ie

ABC Ltd/123 High Street/ London/ N15 ABC

The post code in the final column could be either 6 digits (as above with
space in middle) or 5 digits ie B1 EDR, 7 digits ie WC1A BNM

I have another spreadsheet detailing a sales consultant with the postcodes
they cover ie

Sally Smith/ N15
Audrey Green/B12
Geoff Smith/B15

I need to get the Sales Consultants name into the Customer spreadsheet -
there are 8,500 lines so I need something automated rather than a manual task.

Can anyone help?

Many thanks - Elaine
--
Elaine