Ignoring Blank Cells But Keeping Index of Non-Blank Cells w/ Data Validation and ScrollRow

Hi folks!

My question seems simple and straightforward but I can't my wrap my head around it.

I have a Data Validation list using a named range which includes blank cells. When I click on an item from the list, the excel sheet scrolls to that cell using this formula:

Please Login or Register  to view this content.

The issue is, the list includes the blanks also. Can someone help me figure out how to get rid of the blank cells but keep the original row value of the non-blank cells (since the Linked Cell shows the order value and not the actual row index)?

Attached is what I have so far.

Thank you so much.

EDIT: I do not mind using ActiveX controls if there is a solution available using that method.