stefanoste78
Member
Good morning.
I have a city file with postal code, city, provinces etc sheet "ITALIAN CITIES").
Starting from the "ADDRESSES" sheet, I would need a formula that lays out the address by first entering the street (the part after ")", then the postal code and then the city and province initials "in round brackets", after the street and before the city I should enter the postal code (first column of the following sheet), comparing column B of the "addresses" sheet with column "C" of the other sheet and the city and abbreviation of the province present in the address column of the first sheet and columns B and D of the second sheet.
Can you help me?
I made an example in the first cell.
I have a city file with postal code, city, provinces etc sheet "ITALIAN CITIES").
Starting from the "ADDRESSES" sheet, I would need a formula that lays out the address by first entering the street (the part after ")", then the postal code and then the city and province initials "in round brackets", after the street and before the city I should enter the postal code (first column of the following sheet), comparing column B of the "addresses" sheet with column "C" of the other sheet and the city and abbreviation of the province present in the address column of the first sheet and columns B and D of the second sheet.
Can you help me?
I made an example in the first cell.