Returns a value for a given measure for a specific filter.
Syntax
XL3LookupTabular( Connection, Measure, [Column1], [Value1],…, [Column14], [Value14] )
Parameters
| Parameter | Description |
| Connection | Connection number to use |
| Measure | Measure to calculate |
| Column1,…, ColumnN | Name of the hierarchy that the following value applies to for example, "'Date[Year]'" or "'Customer Geography'[City]". |
| Value1,…, ValueN | Value for the preceding column. Can be text, numeric, date, or Boolean. |
Examples
Revenue 2004.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004 )
Revenue 2004, USA.
=XL3LookupTabular( 1, "Revenue", "'Date'[Year]", 2004, "'Geography'[Country]", "USA" )
