SAP Knowledge Base Article - Public

1203972 - VLOOKUP works in Excel but not in Dashboard/Xcelsius


VLOOKUP works in Excel but not in Dashboard/Xcelsius.


  • Xcelsius 2008
  • Dashboards 4.0
  • Dashboards 4.1
  • Dashboards 4.2


The user might have the indexes for the VLOOKUP changing dynamically. This is not supported. The following is taken from the user guide:
Formulas are only partially supported for the index column of the lookup array. If the index column of the lookup array is a formula, the cell will always contain the initial value. Runtime changes to the value of that cell will not be reflected in the lookup array. Functions will work properly in all other columns of the lookup array. All other columns will contain the current value of a formula at runtime.


  • Use a combination of INDEX and MATCH functions to return the values from your range.


Xcelsius, 7250479, VLOOKUP, index column , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2 ; SAP BusinessObjects Xcelsius Enterprise 2008