Mar 27 2020 05:40 AM
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
Mar 27 2020 05:48 AM
Mar 27 2020 05:58 AM
Hi Jan, thanks so much for your fast reply!
How can I anonimize the over 1.000 customer names and dates?
Mar 27 2020 06:24 AM
Mar 27 2020 06:44 AM
That´s an easy solution I didn´t think about that, thank you!
Attached the table, when you enter name 1, it should show street 1, etc.
But when entering for example name 995, it shows a complete different street.
Thnaks for the help!
Mar 27 2020 06:53 AM - edited Mar 27 2020 06:54 AM
Most common error in VLOOKUP(). You didn't put in the fourth parameter Bereich_Verweis. Excel then assumes TRUE (WAHR) but it must be FALSE (FALSCH).
=WENN(ISTNV(SVERWEIS(B2;Kundendaten!$A$2:Kundendaten!$D$1986;2;FALSCH));" ";SVERWEIS(B2;Kundendaten!$A$2:Kundendaten!$D$1986;2;FALSCH))
Mar 27 2020 07:29 AM