This will expand from B4 to last row with number.Then match what you want. HTH

index(B4:INDEX(B:B,MATCH(1E+30,B:B))