SAP Knowledge Base Article - Public

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

Symptom

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

Cause

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.

Resolution

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.

Keywords

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

Product

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