I think i didnt make myself clear enough

Get row number from a closed workbook

I am trying to get the row number, where the criteria meets a certain value


The search string is "PRO123456" and the column to search is "A1" - when it match i would like it to tell me the rownumber