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, April 22, 2015
yogi_LookUp Scores For Specified Names If There Are Matching Scores For Corresponding Names In Sheet1 And Sheet2
Google Spreadsheet Post #1948 Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Apr-22, 2015 question by Ms. Cleveland:
I have 2 separate spreadsheets that I want to compare. First, I want to compare names in 2 columns in different spreadsheets/tabs. Second, it their is a match, compare the numbers in 2 columns in different spreasheets/tabs that are associated with the name match. Last, if the names and numbers match, place the number next to the name in another column, in the second spreadsheet. The names in the last column are already populated. Here is what I have so far.