overwrite headers after match

[Starchaser]

Hi everybody,

in my example I would like the following :

1. in sheet "Original" I want the headers to be compared with column A of sheet "Match". If there's a match, the header should be overwritten with the text of column B.

I allready figured out how to make the match (INDEX - MATCH formula), but I'm stuck with overwriting the headers

2. The columns marked with "-" should be deleted

Thank you for the advice

Sheet "match" :

Article	ART
Description FR	-
Description D	ARTNAME
Supplier Ref	SUPCODE
BUYER PR	BPR
REDUCTION	RED1
NETT	-
SELLING PR	SPR
SELLING PR VAT	-
PACKAGE	-
UNIT FR	-
UNIT D	UNIT
MIN Q ORDER	MINQ
VOLUME FR	-
VOLUME D	-
VAT	VATCODE
BEBAT	-
EZB	-
HEADGR	HDGRP
SUB	SUBGRP

<colgroup><col width="149" style="width: 112pt; mso-width-source: userset; mso-width-alt: 5290;"> <col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;"> <tbody> </tbody>

Sheet "Original" :

Article

Description FR

Description D

Supplier Ref

BUYER PR

REDUCTION

NETT

SELLING PR

SELLING PR VAT

PACKAGE

UNIT FR

UNIT D

MIN Q ORDER

VOLUME FR

VOLUME D

VAT

BEBAT

EZB

HEADGR

SUB

<colgroup><col width="46" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1621;"> <col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3299;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3100;"> <col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2844;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2360;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="38" style="width: 29pt; mso-width-source: userset; mso-width-alt: 1365;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2702;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3726;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2304;"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1962;"> <col width="50" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1763;"> <col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 3242;"> <col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="74" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2616;"> <col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1137;"> <col width="50" style="width: 37pt; mso-width-source: userset; mso-width-alt: 1763;"> <col width="30" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1052;"> <col width="58" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2048;"> <col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1137;"> <tbody> </tbody>