Vlookup only half villed

[Shimazu]

Hello,

I added new clients and numbers in my sheets.
When i did this i only get half villed data on sheet OUTPUT cell A.

Please Login or Register  to view this content.

[bstier]

I just looked at your spreadsheet. The problem you are having is due to the range on the Debiteuren sheet. Some of the items have a space after the entry. For example "10 voor 5" is on the Debiteuren sheet as "10 voor 5_" these have to be exactly the same. To make it work go through you list and make sure to delete the extra space at the end. This should clear up most of your problems. There were two other problems that need to be corrected as well. Channel Cruises Holland was in the list as Channel Cruises ... this needs to be changed to "Channel Cruises Holland". Pieter Smit Show Services was in the list without the s at the end of Services. Vlookups are great but they have to match exactly!!

[Shimazu]

Ok thank you...so you need to be really accured with this..hahaha beginner here XD