提取数据透视表行标签(非值) [英] Extract Pivot Table Row Label (not value)

问题描述

在Excel 2010中，我有一个紧凑的数据透视表，带有3个行标签(代表管理层次结构).特定行中显示的3个管理级别中的哪个级别每天都会更改.(源数据位于另一个电子表格中，其中的字段Manager L3，Manager L2和Manager L1分别位于其下的John Smith，Gary Glen和Bob Stevens列中.)

在数据透视表旁边的列中，我需要捕获显示的行标签.

然后对其运行 VLOOKUP : = VLOOKUP(A45，Sheet1！$ A $ 1:$ B $ 6,2，FALSE)

您已将该公式放在工作表的 B45 单元格中并向下拖动.

In Excel 2010, I have a pivot table, in compact form, with 3 Row Labels (that represent a management hierarchy). Which of the 3 management levels is displayed in a particular row will change from day to day. (The source data is on another spreadsheet with the fields Manager L3, Manager L2 and Manager L1 in columns with John Smith, Gary Glen and Bob Stevens under them, respectively.)

In the column next to the pivot table, I need to capture which row label is being shown.

Pivot Table example

Is there a formula I can use to produce that info?

Let me know if you need more information. Thank you in advance.

解决方案

Like I said above, I believe your solution would be to create an array on another (hidden) sheet like:

Then run a VLOOKUP to it: =VLOOKUP(A45,Sheet1!$A$1:$B$6,2,FALSE)

You'd put that formula in cell B45 on your sheet and drag down.

这篇关于提取数据透视表行标签(非值)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！