Find text and return row number

In Calc, is there a formula to find a text (like “hello”) in a range of cells and return the row number of the first occurrence?

Don’t think this should be closed as accepted answer is not quite right. OP wants to search a range of cells and get row of first match and doubt SEARCH function is doing that. My answer would be to use MATCH function as it’s doing exactly that: =MATCH("searchFor";B1:B1000;0).

i want to search a text and then show the row.

match its not working, vlookup and hlookup either


Are you askling for the SEARCH function? Text Functions - LibreOffice Help

Also you may refer to Calc Guide Appendix (B) for Functions: