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?

[former_member377358]

Hi All

I am using vlook up in AO, but my question is that in case of vlook i am selecting a data set to do the look up. but when i am refreshing the report the data is not showing up for the new coloumns which added up to the report.

is this behave this way or i need to check some settings.

Thanks

karan

[j_dekievit]

Hi Stefan,

I also faced the same issue. After a lot of searching I came up with this solution for the issue. Please look in your options in Excel. Choose Formulas. Uncheck the Formula Auto complete. This will solve the issue (at least in my case) After this you can enter the formula and it will hold the relative positioning in your Workbook.

[stefan_rottwinkel]

Hi Tammy,

thanks for the hint. I could update it for myself, but I would like to provide the report to some other users. Most of them still using 2.4, due to company policies. I will have to use a macro then for now.