How to add data in to first sheet by considering data in second sheet?

[#1]

Hi,

I have two sheets information in excel

one sheet A have column

address

22 Stavordale Road, Moreton, Wirral, UOI

and another sheet B have columns

Part of address    customer
Wirral               XXXXXX

would it be possible to add another column in sheet A as Customer by making look up value of column part of address from sheet B

Please can anyone suggest me

Thanks.
   

[Gysbert_Wassenaar]

Load the table on sheet B as a mapping table and use the applymap function to add the customer field from the mapping table to the table from sheet A. Something like this:

Map1:

mapping load [Part of address], customer

from ...excel_sheet_b...;

TableA:

LOAD address, applymap('Map1',subfield(address,',',3)) as customer

from ...excel_sheet_a...;