Copy distinct string by by matching items that meet a criterion in excel Filed in Excel

I need to copy a value when two criteria are met in two tables. Table A contains name of District, name of municipality, and code of municipality. Table B contains name of district, code of municipality and administrative unit of municipality. In Table A, there are 50 districts and 40 municipalities (200 rows). But Table B contains data of 50 districts, 40 municipalities and 15 administrative unit of municipalities (3000 rows).

My problem: copy name of municipality in Table B, when name of district and code municipality match in Table A and Table B to all administrate units of Table B.