The following is the data:

Part# Price1 Price2 Price3 Rank1 Rank2 Rank3
a1 10 25 10 1 3 1
a2 60 60 45 2 2 1

I want to recast the above data in the order of the rank as follows:

Part# Price1 Price2 Price3 Rank1 Rank2 Rank3
a1 10 10 25 1 1 3
a2 45 60 60 1 2 2

Basically, it boils down as to how to lookup multiple values for the same
value. Vlookup accesses the same value for the first occurence only.

I would greatly appreciate your suggestion. Thanks in advance.

Roger