I have a worksheet with several columns and rows of data. I have a search engine at the top where if I type in a value, it gives me all the rows which contain that value for that column category. One column contains serial number ranges. For example, each cell in column F (Serial Number) look like this:

F1: 140000-141150
F2: 141151-150000

What I require is that if I type in serial number 140020 in my search cell, it should return row 1. I tried using the LEFT, RIGHT and MID functions but they only work if I type in the range ends (i.e. 140000, 141150, 141151, 150000 etc). Any help would be appreciated! Thanks!