SAP Knowledge Base Article - Public

1203176 - Formula-based indexes for VLOOKUP array are not changing at run time


Formula-based indexes for your VLOOKUP array are not changing at run time.


In order to maintain the speed and efficiency of the VLOOKUP function, Crystal Xcelsius does not recalculate formulas in the index column of a VLOOKUP array.


If you have a VLOOKUP function that contains a formula in the index column, the index column cell will always contain the initial value of the formula.


Xcelsius runtime , 66577 , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem


SAP BusinessObjects Dashboards 3.0 ; SAP BusinessObjects Dashboards 3.5 ; SAP BusinessObjects Dashboards 4.5 ; SAP BusinessObjects Dashboards software 4.0