Get pivot row header name if text matches

[123excel]

Hi, I need to get a pivot row header name to another cell if another cell matches.

DETAILED EXPLANATION:
Se example of pivot table below.

I have two sheets, lets call them "data" (sheet with pivot table) and "result" (without pivot table). If any text in C:C (in "result") matches any of the text in "data" pivot table (B:B), I want it to get the Row header name in the cell at the right. Lets say C3 matches Text 5, then in D3 I want it to say "ROW HEADER 2".

------------PIVOT TABLE------------
[TABLE="width: 317"]
<colgroup><col></colgroup><tbody>[TR]
[TD]+ROW HEADER[/TD]
[/TR]
[TR]
[TD]Text 1[/TD]
[/TR]
[TR]
[TD]Text 2[/TD]
[/TR]
[TR]
[TD]Text 3[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]+ROW HEADER 2[/TD]
[/TR]
[TR]
[TD]Text 4[/TD]
[/TR]
[TR]
[TD]Text 5[/TD]
[/TR]
[TR]
[TD]Text 6
-----------PIVOT TABLE-----------[/TD]
[/TR]
</tbody>[/TABLE]

 

[jarjarbingie]

Hi, I need to get a pivot row header name to another cell if another cell matches.

DETAILED EXPLANATION:
Se example of pivot table below.

I have two sheets, lets call them "data" (sheet with pivot table) and "result" (without pivot table). If any text in C:C (in "result") matches any of the text in "data" pivot table (B:B), I want it to get the Row header name in the cell at the right. Lets say C3 matches Text 5, then in D3 I want it to say "ROW HEADER 2".

------------PIVOT TABLE------------
[TABLE="width: 317"]
<tbody>[TR]
[TD]+ROW HEADER[/TD]
[/TR]
[TR]
[TD]Text 1[/TD]
[/TR]
[TR]
[TD]Text 2[/TD]
[/TR]
[TR]
[TD]Text 3[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]+ROW HEADER 2[/TD]
[/TR]
[TR]
[TD]Text 4[/TD]
[/TR]
[TR]
[TD]Text 5[/TD]
[/TR]
[TR]
[TD]Text 6
-----------PIVOT TABLE-----------[/TD]
[/TR]
</tbody>[/TABLE]

easiest solution would be to change the layout of the pivot table to tabular form so you'll get 2 separate columns and toggle repeat all item labels.. this way, you can just use this formula to return the header:

=INDEX(Data!B:B,MATCH(C3,Data!C:C,0))