Hello!
Surely someone can solve this one!
In sheet 1 you will find a customer list (customer & their customer number) & I need to find for each customer their tarif in sheet 2. In sheet 2 you will find a list of customers without customer number but with their tarif. Moreover, in 2 cases the customer name is not a 100% identical (only the first part).
How can I solve this?
Best regards, DOJA
Last edited by Doja; 11-29-2020 at 05:19 AM.
Please try at C2
=VLOOKUP(LEFT(B2;FIND(" ",B2&" ")-1)&"*";Blad2!$A$2:$B$8;2;0)
This seems to cover it:
=IFERROR(VLOOKUP(IFERROR(LEFT(B2,FIND(" ",B2)-1),B2&"*"),Blad2!$A$2:$B$8,2,0),VLOOKUP(B2,Blad2!$A$2:$B$8,2,0))
You may need to replace commas with semi-colons for your locale.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thnx for solving this problem! great!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks