Forum Discussion

Julian0706's avatar
Julian0706
Copper Contributor
Mar 27, 2020

Excel VLookup bug

Dear Team!

 

I have problems with a german excel table, which has over 1.000 rows of customer data and a VLOOKUP formula that should get data out of it.

A Microsoft Office Support employee took an hour to help me but then he gave me the link to this support page, as there seems to be an bug which he couldn´t resolve.

 

The V Lookup formula works just perfect until a specific row, after that row, or sometimes even after different rows, it gives out wrong data from a complete different row.

 

Am I right here for help regarding this bug?

 

Thanks a lot! Best regards,

Julian

excel

6 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Mar 27, 2020
    Hi Julian,

    Can you please upload a (anonimized) copy of your file?
    • Julian0706's avatar
      Julian0706
      Copper Contributor
      Mar 27, 2020

      Hi Jan, thanks so much for your fast reply!

       

      How can I anonimize the over 1.000 customer names and dates?

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Mar 27, 2020
        In the name column, in the first cell with a name just type Name 1 and press enter. Then double-click the fill handle to fill that down. Now that the names are "gone" I expect there isn't much point in changing the dates. You can do the same for any other textual column (like with addresses, just type Street 1 and fill that down).

Resources