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------------

+ROW HEADER

Text 1

Text 2

Text 3

+ROW HEADER 2

Text 4

Text 5

Text 6 -----------PIVOT TABLE-----------

<colgroup><col></colgroup><tbody>
</tbody>

 

[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------------

+ROW HEADER

Text 1

Text 2

Text 3

+ROW HEADER 2

Text 4

Text 5

Text 6 -----------PIVOT TABLE-----------

<tbody>
</tbody>

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))