CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formulamatchrowvlookup
Tiodani
Tiodani

Reputation: 125

Google sheets: How to get the row number of a cell in a different sheet?

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.

Upvotes: 1

Views: 3207

Answers (2)

player0
player0

Reputation: 1

try:

=MATCH(A1; Sheet1!A:A; 0)

where A1 is somewhere in Sheet1 A column

Upvotes: 1

Osm
Osm

Reputation: 2881

Use this formula

=ArrayFormula(QUERY(IF(Sheet2!A:A=A2,ROW(Sheet2!A:A),"")," Where Col1 is not null",0))

enter image description here

Upvotes: 1

Related Questions