Rearranging and renumbering data in rows

[jenn247]

Is it possible to rearrange data in column B if i change the corresponding
number in column A? Can I also at the same time rearrange data in column B
while retaining the corresponding number in column A?

 

[Max]

For better answers, illustrate simply what you have and want to do. Post some
sample data for cols A and B (what you have). Then show the results that you
want to happen, ie the "after" scenarios, explaining how these results are to
be achieved.

 

[jenn247]

Thank you Max. I realize that this is probably a very basic function but
have not been able to find if it can be done.

I would like to convert data as in step 1 to step 2 to step 3 using many
more rows but just the two columns, if possilble, more quickly. Is there a
simple way to do it or a formula I should be using?

Step 1
Colours
1 Black
2 Tan
3 Brindle
4 Fawn


Step 2
Colours
3 Brindle
1 Black
2 Tan
4 Fawn

Step 3
Colours
1 Brindle
2 Black
3 Tan
4 Fawn

Thank you.

 

[Max]

Taking this to be your base association table

1 Black
2 Tan
3 Brindle
4 Fawn

You can use this anywhere to return the colours based on the lookup nums 1-4
Eg with lookup nums in A6 down, place this in B6:
=INDEX({"Black";"Tan";"Brindle";"Fawn"},MATCH(A6,{1;2;3;4},0))
Copy down. Any joy? hit the YES below