Other way to use "Getpivotdata"?

[Cindy]

Usually, we would define the following macro statement to
get value from an OLAP cube in Excel.

GETPIVOTDATA("[Measures].
[Sales]",$A$4, "[Months]", "[Months].[January]")

I would like to know whether there is another to
use "Getpivotdata". For example, assign an array
to "Getpivotdata".

Thanks!

Cindy

 

[BrianB]

I hate this method and use VLOOKUP() all the time. No probs at all