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

NBVC · #1 02-08-2019, 12:03 PM

Try:

=SUMIFS(INDIRECT("'year "&RIGHT(F$1,2)&"'!$G:$G"),INDIRECT("'year "&RIGHT(F$1,2)&"'!$B:$B"),$C2,INDIRECT("'year "&RIGHT(F$1,2)&"'!$D:$D"),$D2)

copied across and down

Oluagbe1 · #2 02-08-2019, 01:30 PM

Quote:

Originally Posted by NBVC

Try:

=SUMIFS(INDIRECT("'year "&RIGHT(F$1,2)&"'!$G:$G"),INDIRECT("'year "&RIGHT(F$1,2)&"'!$B:$B"),$C2,INDIRECT("'year "&RIGHT(F$1,2)&"'!$D:$D"),$D2)

copied across and down

Thank you very much for your response.

The formula you sent worked perfectly well in the test attachment I sent at the beginning of the thread however when I used it on the actual document, it did not work and I can't explain why.

Please I need more assistance and I have also attached a copy of the actual document here

Marcia · #3 02-11-2019, 06:01 AM

Review the names in the cummulative sheet, they do not exactly match the names in the years sheet. You were not consistent on the placements of the "Mrs" and "Mr". Also, if you want to be alerted of duplicated Oracle Numbers, a simple conditional formatting will do that for you.

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