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
https://docs.google.com/
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.
No comments:
Post a Comment