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
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
Hi,
Are you askling for the SEARCH function? Text Functions - LibreOffice Help
Also you may refer to Calc Guide Appendix (B) for Functions:
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide