Forum Discussion

Susanne2020's avatar
Susanne2020
Copper Contributor
Aug 31, 2020

Pivot and vlookup

Hello,    I have made a pivot table, where I use a field in the filter to lookup another informations. For example I use the customer number as a filter in the pivot - but I also use it to 'vlookup...
excel
Formulas and Functions
Macros and VBA
training
mathetes's avatar
mathetes
Silver Contributor
Aug 31, 2020

Susanne2020 

 

It sounds like you've done a reasonable search for possible causes. Is it possible for you to post a copy of the spreadsheet(s), just making sure first to remove any actual names, addresses, etc.--i.e., any and all confidential or personal info.

 

  • Susanne2020's avatar
    Susanne2020
    Copper Contributor
    Sep 01, 2020

    mathetesand SergeiBaklan - thank you for your answers. 

     

    Now I have made a light version of the spreadsheet :

    On sheet 'Pr. kunde' - in field 'CustAddrNo' :

    If I use no. 2001792 everything is fine.

    If I use no. 2001811 my lookups are interrupted.

     

    I have tried SergeiBaklan's suggestions and it seems to be text now. 

    How did that happened ? (I know it happened when I by a mistake overwrite the number and then changed it back - but why did it then became text ?)

    How do I correct it ?

    And how do I prevent other users to do the same failure ?

     

    Hope you can help 🙂

Resources