Obtaining the row number of a cell that fulfills a certain criterion
Is there a function that will return the row number of the (first) cell in a certain column that fulfills a criterion, e.g. begins with "XYZ" or is larger than X. That will allow me to obtain the data of a relevant cell in a different column, similar to the function of the VLOOKUP-function i Excel.Preferably I want to do it in the Formula editor.
