=MATCH(1,B3:B33,0)

Should do what I think you need

I have assumed data is as follows

TITLE
Product ref #12345


hth RES