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

		Microsoft Office Forums > Microsoft Excel > Excel
How to match one list with another and return certain values from corresponding cells in excel

FAQ

Thread Tools

Display Modes

02-11-2019, 05:47 AM

NBVC

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

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

The matches must be exact matches. I noted many times you have Mr or Mrs in brackets following the names in the 2015, 2016 and 2017 but in the cumulative sheet the Mr and Mrs is in front of the names...

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:45 AM.