How to ignore blank matches with an index and choose the next match (if multiple matches)

Hi

I have set up an index and there may be multiple matches possible from the results.

That is fine - as long as the first match isnt a blank. I need it to skip past any blank matches and choose the first completed field that matches.

Examples attached.

Thanks

Hi,

I thought that it would only matter if the gap came first? Doesnt the formula select the first match?

Therefore if the gap was in the middle I assumed it would have already matched a name

Is this something that could be addressed with an If statement before the indexing formula? If so, I cant figure it out - any help would be much appreciated.

Thansk