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-08-2019, 12:03 PM

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

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

« 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.