Two criteria search in a matrix

		Microsoft Office Forums > Microsoft Excel > Excel
Two criteria search in a matrix

FAQ

Thread Tools

Display Modes

02-14-2017, 12:42 AM

xor

Windows 10 Two criteria search in a matrix

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

With row number (orange) in B22, time in B23 and the following in B24 (a helper cell):

="R"&MATCH(B22;B2:B17;0)+1&"C3:R"&MATCH(B22;B2:B17 ;0)+1&"C34"
you can try the following:

=INDEX(C18:AH18;MATCH(B23;INDIRECT(B24;0);0))

Last edited by xor; 02-14-2017 at 03:15 AM.

Tags

match/index, sumif, vlookup

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use CSV as search criteria for Outlook search folder	lonesoac0	Outlook	0	03-07-2016 02:31 PM
Search for date and then apply mutliple search criteria in huge dataset	maxtymo	Excel	2	12-01-2013 04:52 AM
Display if search criteria is not met	meppwc	Excel	2	03-23-2013 10:48 AM
Search Folder sent to criteria	markstro	Outlook	0	12-20-2011 02:47 PM
Criteria in Outlook Search	Nancy Grams	Outlook	0	11-12-2009 03:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 PM.