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 :)
suthandira you are welcome