Ordering one table by the rules from another table

OPk

I have a formula for you

=OFFSET($E1,0,MATCH(J1,$A1:$D1,0)-1)

Your Sample data is wrong in rows 3, 4 and 8 ( All row 3, All row4, and last column row 8)

Originally Posted by mehmetcik

OPk

I have a formula for you

=OFFSET($E1,0,MATCH(J1,$A1:$D1,0)-1)

Your Sample data is wrong in rows 3, 4 and 8 ( All row 3, All row4, and last column row 8)

Thanks for your efforts! I really appreciate it! There is a problem however. In the row 8 of your file you can see that the OFFSET formula produces double 67s instead of 67-44 (interchangeable order).