Answer the question
In order to leave comments, you need to log in
Getting row number using MATCH function in google spreadsheets?
The situation is this, there are 2 Google spreadsheets. I pull out the data of columns (serial numbers) from them through IMPORTRANGE. That is, 1 formula in the first line per column and the column is immediately filled with numbers. It is necessary to compare the columns and get the ordinal number of the row in the second column. Well, that is, in the first column, for example, the number 100 is on the 100th line, and in the second on the 30th line. It is necessary to display 30 in the third column in the hundredth line, for example. I'm trying to do this through the MATCH function, but it always returns #N/A, although if you write one of the values \u200b\u200bwith handles in any other column without autocomplete and specify the range of the column without autocomplete in the match search arguments, it returns the correct result. Actually the question is how to do it?
My function looks like this: "=MATCH(A1;B:B;0)" and I stretch the column and the following lines are auto-completed with the change of the first argument (A2,A3,A4, etc.)
Answer the question
In order to leave comments, you need to log in
Hmm, I couldn't reproduce. More precisely, he could, but only if you =MATCH(A1;B:B;0)
quote the first parameter, or specify an [invalid] column in the second parameter, with empty cells.
For simplicity, I threw it in one table in three sheets, then scattered the sheets over the tables. In the pivot table
A1 =IMPORTRANGE("TABLE1_URL"; "Лист1!A:A")
B1 =IMPORTRANGE("TABLE2_URL"; "Лист2!A:A")
C1 =MATCH(A1;B:B;0)
, replicated by stretching down as much as necessary.
Are the imported columns themselves loaded?
MATCH on imported columns generally always #N/A
shows?
Does the function in the third column really look like this? =MATCH(A1;B:B;0)
In copies of the function in the underlying cells, do cell references change correctly?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question