Microsoft Office Forums - View Single Post - Two criteria search in a matrix

Thread: Two criteria search in a matrix

View Single Post

Old

02-14-2017, 12:42 AM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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.

Reply With Quote