How to match data in rows

[GLamberson]

I thought this would be an easy problem but am really struggling. I have data in rows on Sheet 1:

11 12 13 14
.6 .5 .4 .3

On this example, the starting #,11, will vary from time to time.

On Sheet 2, I have rows:
1 2 3 4 5 6 7 8 9 10 11 12 13 14

What I need to do is match the values in Sheet 1 with the corresponding # on Sheet 2 so I would get:

1 2 3 4 5 6 7 8 9 10 11 12 13 14
0 0 0 0 0 0 0 0 0 0 .6 .5 .4 .3

Any suggestions?

 

[Z51]

You could try HLOOKUP, for example:

Sheet1 row 1 are values you want to look up.
Sheet1 row 2 are values you want to return based on the search.
Sheet2 row 1 (A1:_1) are values, e.g. 1, 2, 3, 4, 5, etc..

In Sheet2 cell A2 use:

=IFERROR(HLOOKUP(A1,Sheet1!1:2,2,0),0)

 

[GLamberson]

Thank you Z51, but that isn't working. My example above is cluttered. Unfortunately, I have not been able to set up to download the spreadsheet, but I did do a screen capture of Sheet 1 and Sheet2.

Sheet 1

Sheet 2