I couldn't get that to work. I'm trying to search column 5 for the number 1000. When I used the formula, it gave me a number that was around row 1000 and a value of 5231.