Find text and return row number

English
, , ,
#1

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

#2

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

#3

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

match its not working, vlookup and hlookup either

#4

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

#5

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.