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
Reply With Quote
