With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, December 12, 2012
yogi_Extract First Matching Value In Column C Of Sheet2 With Specified Conditions Including Specified Exact Match
Google Spreadsheet Post #926
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Dec 12, 2012 user Thuong MCB said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/uIdd4LfmLO4) Disgusting between upper and lower case Hello.
I have a speadsheet like this:
in another sheet, I want to combine mail and Mail together. The function I use is Match and index. But I can not because spreadsheet think mail and Mail are the same.
Please help me solve this.
I use this function to get Mail data from that source
user Thuong MCB is looking for an exact (case sensitive match) for mail in column B of Source!2012 ... I had a little play with it and I have offered several solutions including those similar to ones that have already been provided