Basically, in the expression I'm writing, it searches for a certain text in an interval in a different sheet using VLOOKUP, and if it finds it, it must get the number of the row the text is. I can't find a simple way of doing the second step, since as far as I know, VLOOKUP can only return the searched value, and ROW can only be used to return the line number of the current sheet.
try:
=MATCH(A1; Sheet1!A:A; 0)
where A1 is somewhere in Sheet1 A column