Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 03 at 11:18 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 04 at 07:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 08 at 09:07 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 09 at 01:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded