Ask Your Question

Find text and return row number [closed]

asked 2013-07-15 16:50:02 +0100

CMKT gravatar image

Hi, 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? Thanks

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 23:17:09.143071


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).

Kruno gravatar imageKruno ( 2018-05-07 08:31:58 +0100 )edit

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

match its not working, vlookup and hlookup either gravatar ( 2020-03-19 20:44:13 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2013-07-15 19:35:44 +0100

Zeki Bildirici gravatar image


Are you askling for the SEARCH function?

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

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-15 16:50:02 +0100

Seen: 6,417 times

Last updated: Jul 15 '13