Index Match to Skip/Ignore Blanks in Row

Hi All,

Help please... I need to develop an INDEX MATCH formula to ignore/skip blanks within row/range lookup.

I have attached an example workbook that highlights (yellow cell fill) the current INDEX MATCH formula that returns an "#N/A", and also an example of the expected results. Essentially the INDEX MATCH formulas get their ranges from an INDIRECT scenario but are pretty standard otherwise.

Any help will be greatly appreciated. Thank you