Forum Discussion
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...
Hi Sergei Many thanks. It works with "trim" but only on those that I did not copy from table 1 to table two. It looks like ti works on those with spaces and those that have no spaces the original formula works. Can I combine the two versions? One with trim and the other without. What i don't understand is why it works when I copy past from tabkle 1 to table 2 even so the formating is exactly the same. Tried to upload the table but can't find a button Again thanks Regards Jacqueline
You may use TRIM in any case, it'll be more safe