Insert Excel Formula (Vlookup) With TableDesign in Analysis for Office

[stefan_rottwinkel]

Hi everyone,

I have used a Vlookup with Table Design as shown in this YouTube video

Insert Excel Formula (Vlookup) With TableDesign

It works, but after I refresh the DataSource, the Vlookup remains only in the first row. So in the example C18:C21 would be empty and the report would look like this.

I use Analyse 2.5.

Does anyone have an idea? Thanks in advance.

[TammyPowlas · Accepted solution]

Hello Stefan - I just tried using VLOOKUP with refresh in 2.6 SP1 and it works fine. Any chance you could update your Analysis Office to 2.6 SP1?