Vlookup but a little more complicated

[dinker454]

I am stuck on how I can manipulate the data I have into what I want. In Column A, I have ID numbers for each product. In Column B-H, I have positions 1 through 7. The last digit of each Column A ID corresponds with the position number in the same row. What I want is to match the position with the ID and have the values for that position to match with the ID. I know this is confusing, so I attached a worksheet. Any and all help is greatly appreciated.

[XOR LX]

Cross-post:

http://www.mrexcel.com/forum/excel-q...mplicated.html

[JieJenn]

In B22 enter

=VLOOKUP(A22,$A$4:$H$18,RIGHT(A22,1)+1,0) and drag it down