Like any good topic on MrExcel, this one begins with me pulling my hair out in frustration!
I've constructed a fairly straightforward Index/Match formula that involves a couple of columns within Tables in Excel's main interface that looks something like this:
=INDEX(A_OpenClose[Total Open...