Challenge with the Index formula

That's a nice answer ImokatExcel. I took a slightly different (and maybe overcomplicated) approach, which needed a couple of helper columns (which can be hidden, of course), but which also filled in column H. Messier than yours, but... maybe... complete. we'll see.