Forum Discussion
Solved
Fetch specific cell value which matches the RowName and ColumnName
Is it possible to create a "Excel formula" where it returns the value of the cell (or) row number and column number when it matches with the specific row name and column name. For example:I need ...
suthandira , for such sample
it'll be
=GETPIVOTDATA("[Measures].[Sum of C]",$F$5,"[Table1].[A]","[Table1].[A].&[MRO2]","[Table1].[B]","[Table1].[B].&[AMS]")The easiest way to generate the formula - type "=" in any empty cell and click on proper cell within your PivotTable. After that you may play with adjustments.
suthandira , for such sample
it'll be
=GETPIVOTDATA("[Measures].[Sum of C]",$F$5,"[Table1].[A]","[Table1].[A].&[MRO2]","[Table1].[B]","[Table1].[B].&[AMS]")
The easiest way to generate the formula - type "=" in any empty cell and click on proper cell within your PivotTable. After that you may play with adjustments.
- Thank you soo much it works for pivot table but how can we fetch value if the table is not a pivot table(Normal Table).Is it possible to get the value?
suthandira , yes, for the table2 like this
that is
=INDEX(Table2[#All], MATCH("MRO2",Table2[[#All],[Row Labels]],0), MATCH("AMS",Table2[#Headers],0))- Thank you soo much for helping me :)
