wrote
.. Are there similar formulas just to return
the row number instead of the the complete cell address?
Preferably without using arrays.

Array-entered in C3:
=MAX((ISNUMBER(SEARCH(B2,A2:A7)))*ROW(A2:A7))
will return the last instance's row number: 5

(Just remove the front part: "A"& ... in the earlier formula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---