Find next cell within column that is a number, starting from reference cell in another sheet

[kidneythief]

Hi! Lol sounds really simple but I'm kind of fumbling with this.
I have 2 sheets, the Sample Sheet attached and an Input Sheet.
In the Input Sheet, I input one of the green shaded values (10001, 10002, 10003) in a cell, say A2.
Is there a way to match A2 in Sample!A:A and move down until I hit the first number (3, 4, 3).
For example, if I my A2 is filled with 10002, I need my formula in another cell to return A14.

My end goal is to actually get to the corresponding yellow shaded cell, and I was thinking I could just
offset after hitting the first number from the reference cell. I hope that makes sense!

 

[Fluff]

Duplicate to: Find cell relative to starting point based on matching reference from another sheet

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.