Lookup value in row against value in column

[opeyemi1]

Hello,
My apologies if this question been asked before. I tried searching the forum but wasn't able to find an exact problem/solution.
I have uploaded a simplified sample.
I have identifiers namely, 1 to 10 arranged in column J (J8 to 17) with corresponding values in columns K to N.

I have the same set of identifiers but now arranged in a row, namely row 25. In K25 for example, I have an identifier "2". I would like a formula that will return the value in column L that corresponds to the identifier 2 for example. Please see shaded area, is there a formula that I can use so that I can just change the position and return the values in columns K to N that matches the identifier in row 25?
I tried vlookup and I couldn't get it to work.

Thanks so much for your attention!
lookuptest.xlsx

[Paul]

Hi Opeyemi,

In cell J26 put this formula:

=VLOOKUP(J$25,$J$8:$N$17,ROW(A3),0)

Fill that down to J28, then across to column S. Disregard the A3, as that will change automatically. ROW(A3) = 3, ROW(D5) = 5, etc. It's just used to return the correct column based on how your data is situated.

[TMS]

J26: =VLOOKUP(J$25,$J$8:$N$17,ROW(A3),FALSE)

copy across and down

Regards, TMS

[opeyemi1]

Thank you Thank you!
I actually didn't know I could use vlookup as well. This is the first time I have come across the row () embedded into vlookup.

Much appreciated!