match data between two sheets and copy word based on header

[ABDELFATTA]

hello
I have data in sheet1 in column A,B , what I want match the headers in sheet2 with the data in sheet1 if the data are matched then should copy the word CASE which is existed in header in sheet1 for instance when match the name ALI and header ***-1 in sheet 2 with the data in sheet1 should copy word CASE of header in sheet1 and put for the name if it's matched see the word CASE in sheet 2 how should be when match the name and the headers

thanks

[jindon]

Formula in C3
=IFERROR(INDEX(SHEET2!$A$1:$F$6,MATCH(A3,SHEET2!$A$1:$A$6,0),MATCH(B3,SHEET2!$A$1:$F$1,0)),"")

vba

Please Login or Register  to view this content.

[sintek]

Another option...

Please Login or Register  to view this content.

[jindon]

If other way around

Please Login or Register  to view this content.

[ABDELFATTA]

@sintek thanks so much for your great answering

[ABDELFATTA]

@jindon thanks , but your codes don't work
the first it shows only values 0 in COL C in sheet1 , it doesn't show the word CASE in sheet2
the second it gives error "application defined or object defined error in this line

[jindon]

.................

[sintek]

Glad I could contribute...Tx for rep +

[jindon]

OOps,, ex 2010
Try change to

Please Login or Register  to view this content.

[ABDELFATTA]

@Jindon many thanks for correcting