Forum Discussion
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...
Hi Julian,
Can you please upload a (anonimized) copy of your file?
Can you please upload a (anonimized) copy of your file?
Hi Jan, thanks so much for your fast reply!
How can I anonimize the over 1.000 customer names and dates?
- 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).
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!
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))
