joelle
09-21-2015, 09:30 AM
Dear "Match functions" expert:
As you can see, please how do I write a match formula for D1 to D4, so that if the customer name matches with the one in A1:A4, the correct value returns in D1 to D4. Ex below shows D1 returns 35 because name matches w/ A3 (ABC). In reality, I have to deal w/ 100 names. Oh, please note that "name sorting" is not an option for my project, or else, LIFE spells "EASY" :)
So much appreciated.
customer CCA
150
customer ABC
35
customer XYZ
20
customer EFF
customer ABC
35
customer CCA
customer EFF
20
customer XYZ
As you can see, please how do I write a match formula for D1 to D4, so that if the customer name matches with the one in A1:A4, the correct value returns in D1 to D4. Ex below shows D1 returns 35 because name matches w/ A3 (ABC). In reality, I have to deal w/ 100 names. Oh, please note that "name sorting" is not an option for my project, or else, LIFE spells "EASY" :)
So much appreciated.
customer CCA
150
customer ABC
35
customer XYZ
20
customer EFF
customer ABC
35
customer CCA
customer EFF
20
customer XYZ