Overclock.net banner

Excel Question :)

354 Views 1 Reply 2 Participants Last post by  mcastaneda68
I have a column of numbers, and another column of numbers. How do I make them automatically line up with the matching number in the other column while having one column not shift. I also need the entire row moved when it finds a match not just that said number (confusing sounding i know :/)

Example:

Before:
1----2---40.00
3----7---37.00
7----3---24.00
2----1---67.00

After
1----1---67.00
3----3---24.00
7----7---37.00
2----2---40.00
1 - 2 of 2 Posts
I would use the functin vlookup, if the "before" table is in A1:C4, I would create the "after" as follows:

A7=A1, A8=A2,...
B7=vlookup(A7,B1:C4,1,false)
C7=vlookup(A7,B1:C4,2,false)
1 - 2 of 2 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top