How to match one list with another and return certain values from corresponding cells in excel

Oluagbe1 · #1 02-08-2019, 09:20 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index Match Formula to return value from a list with criteria	Marcia	Excel	4	10-26-2018 08:59 AM
Loop through cells and return only unique values	trevorc	Excel Programming	4	10-11-2018 03:49 PM
Excel Match return different row number	kimak	Excel	1	03-01-2017 09:39 AM
Compare cells in 2 columns in separate WBs and return data in Col 38-40 if there is match	krispykreme	Excel Programming	1	09-09-2016 11:25 AM
Excel Formula: return a range of cells that match	tinfanide	Excel	4	08-30-2014 07:03 AM