Fill in the corresponding cells

[randr]

Hello everyone!

I would like to fill in corresponding cells with the values I have.
an example:
I have a row from 1 to 10
Below of each number i have a set of numbers

1-2-3-4-5-6-7-8-9-10
55-74-7-8-6-45-2-77-94-10
and lower i have rows of 6 from original 10 row
1-3-5-8-9-10
How to auto fill each corresponding number with the original table?
Thank you in advance!

 

[philwojo]

If you are asking to put the number that corresponds to your original table and values just use the hlookup formula.

I don't know your cells, but here is one example

=HLOOKUP(A10,$A$1:$J$2,2,0)

This will lookup what ever value is in A10 from the list in A1-J2 and give you the value from Row-2.

So put this formula in and copy over to your other cells, that would assume your 2nd set of values is in A9.

 

[randr]

Thank you so much!