PDA

View Full Version : [SOLVED] simple MATCH function - need help



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

Paul_Hossler
09-21-2015, 10:10 AM
Were you thinking of VLookup()?

14433

joelle
09-21-2015, 11:49 AM
Aloha Paul!

YAY - vlookup was actually what I failed to think of! THANK YOU SO VERY MUCH for the quickie charm reply :)