Hello Excel Masters in disguise,
It has been a while.
Have a challenge here and trying to figure out a workaround.
Quite simply, I want to use a formula to look up the nth row match or nth column match using a formula (if it is even possible!)
Please find attached a sample workbook, which clearly explains my desired result using an example.
Bookmarks