Thread: How to match one list with another and return certain values from corresponding cells in excel
View Single Post
 
Old 02-08-2019, 09:20 AM
Oluagbe1 Oluagbe1 is offline Windows 10 Office 2019
Novice
  
Join Date: Feb 2019
Posts: 8
Oluagbe1 is on a distinguished road
Default How to match one list with another and return certain values from corresponding cells in excel
Hello everyone.
Please i need help with my spreadsheet that has multiple information on it.

What i want to do is to pick each years TOTAL SCORE from the yearly sheets and populate the same total scores into the appropriate columns in the cumulative sheet.

And i am supposed to get these scores by matching 2 unique values which are the NAMES, AND ORACLE NO. And if these informations are present, then it will return the total score of that individual into its appropriate year.

The name and oracle number is unique to individuals except where we probably have typographical errors else it's a unique value to all individuals.

Please anyone help me with this task as i have tried severally but all to no avail.

Thank you all.
Attached Files
File Type: xlsx done 2.xlsx (64.9 KB, 10 views)
Reply With Quote