Monday, June 19, 2017

yogi_Match Last And First name Combinations In Another Sheet And Pull Corresponding Points

Google Spreadsheet   Post  #2187
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-19-2017
question by J720:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/Ex97B5LWtNg;context-place=forum/docs
How do I match data to a first & last name
I need help matching a specific number to a specific set of names. As you will see in the below link, I have three names separated by Last Name & First Name in "Sheet1". In Column D of "Sheet1" employees can accrue points, for example D2 for Jane Doe should have 12 points, D3 for Bill Zoe should have 8 points and Johnny Apple in D4 should have 3 points.

The points will be collected from "Sheet2" under cells associated with the "Sheet1" names. Without writing a formula like: =SUM(SUMIF(A:A,{"Zoe, Bill"},K:K)) that is written specifically for an employee's name, is there a way to match the points in Sheet1 column D to the names in Sheet1 Column A&B from the listed names in Sheet 2 row 1?

In Sheet2 row 1, the names are populated using: =Sheet1!A2&", "&Sheet1!B2

By applying this idea to Column D, adding and removing names to the entire workbook and formulas is simplified for me for the future.

I'd appreciate any suggestion.


https://docs.google.com/spreadsheets/d/1zdyEFY4zcRpmvxyBozIJmOXquQfg5LXZOS00lukAKm4/edit?usp=sharing