Microsoft Office Forums - View Single Post - [Solved] How can i retrieve a cell value based on two arrays

Thread: [Solved] How can i retrieve a cell value based on two arrays

View Single Post

Old

10-16-2016, 06:35 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,101

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

=IF(F3>MAX(A2:A4),"",INDEX(B2:d4,MIN(IF(A2:A4>F3,R OW(A2:A4)-1)),MATCH(F2,B1:d1,0)))

It is an array formula so when entering remember to hold down Ctrl and Shift before pressing Enter. If you do it correctly Excel will automatically put braces {} around the formula.

Reply With Quote