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

Marcia · #9 02-11-2019, 06:37 AM

I'm sorry NBVC, I missed reading your second post. At any rate, Oluagbe, I removed the name in the criteria but it would be best if you add the registration number in the criteria. You change "$B:$B" to "$C:$C" (The "C" is the column number of the registration numbers in the year sheets) and the C2 to E2. C2 is the cell address of the name in the cummulative sheet while E2 is the registration number.

I've placed the conditional formatting in columns D and E. Try copying a number and pasting below it, the duplicate number should be colored.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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