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...
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))
Detlef is right, please use the fourth argument of the vlookup function. In your case it must be FALSE.