Forum Discussion
Jacqueline Urbach
Oct 16, 2018Copper Contributor
Sverweis Vlookup does not work properly
My sverweis formula only works if I copy the search criteria data (lower part table 1) D17 to the matrix part ( table 2). I search for the numbers in column C of table 2. At rows 18 and 25 I did this...
SergeiBaklan
Oct 16, 2018Diamond Contributor
Hi Jacqueline,
That's since you have extra spaces in names, try
=VLOOKUP(TRIM(D17),Tabelle2!$A$2:$C$238,3,FALSE)
and attached
"Grüne Kontaktlinsen (Electro Green) " <> "Grüne Kontaktlinsen (Electro Green)"