Difference between revisions of "XL3LookupTabular"
(Created page with "Returns a value for a given measure for a specific filter. ==Syntax== {{Code|XL3LookupTabular( Connection, Measure, [Column1], [Value1],…, [Column14], [Value14] )}} ==Parame...") |
(→See Also) |
||
| Line 32: | Line 32: | ||
[[Category:Formulae]] | [[Category:Formulae]] | ||
| − | |||
Revision as of 16:12, 16 March 2012
Returns a value for a given measure for a specific filter.
Contents
[hide]Syntax
XL3LookupTabular( Connection, Measure, [Column1], [Value1],…, [Column14], [Value14] )
Parameters
| Parameter | Description |
|---|---|
| Connection | Connection number to use |
| Measure | Measure to calculate |
Examples
Revenue 2004.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004 )
Revenue 2004, USA.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004, "'Geography'[Country]", "USA" )
