Return row number

Here is the problem
i am not that smart so please simple solutions
i have two tables side by side
4 7 8 10 14 20 ---------------------- 4 7 8 10 14 20 27 28 33
5 8 10 13 15 17 ---------------------- 5 8 10 13 15 17 22 28 33
4 5 14 20 24 32 ---------------------- 4 5 14 20 24 32 33 35 38
2 4 6 11 15 16 ---------------------- 2 4 6 11 15 16 19 24 28
6 8 11 14 15 16 ---------------------- 6 8 11 14 15 16 20 23 26
7 9 14 23 24 25 ---------------------- 7 9 14 23 24 25 31 32 37
13 20 22 23 25 28 ---------------------- 13 20 22 23 25 28 29 34 35

here is what i need
in table on the right side with 9 columns to find exact macth of numbers the first row in the left table and to return number of row to next to it and so on and on till the end of the left table
thank you

@MIKE1122

Welcome to the excelforum.

Please add in the excel file the expected result for row 1 - 10.

Thanks for the reply.

Please add the result in the excel file and post it again.

Please add addionaly why you expect that result (based on what?)

Please Login or Register  to view this content.

Is it are you looking for?

Another guess:

In I1 copied down:

Formula:

Please Login or Register  to view this content.

Please be patient and don't open duplicate threads. Thanks.

Administrative Note:

More impatience!!!

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

As tiny still have questions in this issue that you need to ask here instead of opening duplicate threads, I have removed the solved tag for now.

Hi,

In your duplicate thread, now closed, I said:
Hi,

Welcome to the forum
This looks like it may be a much simplified example and probably doesn't represent the size or detail of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

If so would you upload your real workbook (or at least a cut down copy), and manually add the results you expect to see.

You agreed that it was an unrepresentative sample but declined to upload a real workbook with any actual data, just saying you wanted a response for your unrepresentative example.

Obviously that's your prerogative but just to let you know I prefer not to waste my time formulating an answer for a simple example that may or may not work with production data.
Long experience tells me that this is unproductive not to say frustrating and I'd rather spend my time on the requests of others who are prepared to offer real data.

If you aren't prepared to help me to help you then I'll back out.

This proposal is for the file attached to post #16.
Q1:Z1 are populated using the numbers of the rows of the range with 4 values
Q2:Z11 are populated using: =SUMPRODUCT(--(ISNUMBER(MATCH($I2:$O2,INDEX($B$2:$E$11,Q$1,),0))))
The row numbers are displayed in column G using: =MATCH(4,INDEX(Q$2:Z$11,,MATCH(A2,Q$1:Z$1,0)),0)
Let us know if you have any questions.