HELP!! PLEASE! Need help Matching columns on the same sheet.

[Sleepyramos]

Hi, I have a bit of a problem, I have 4 columns 2 of those Columns have the same mix of numbers and letters in them, next to those columns are a Money value. I need to match the 2 columns with the mix of numbers and letters to each other and have the columns with the Money value next to it follow where ever it goes. Not sure if there is a way to do this, I know how to match just the Columns with mixed letters and numbers using =Vlookup but that doesnt help when the column next to it with the money value doesn't move along with it makes a huge mess.

Example: What I currently Have on my spread sheet.
A................B.................C....................D
35MSS8......11.00...........37LYGU...........64.00
37LYGU.......10...............36OWZK..........43.00
36OWZK......0.00............35MSS8...........36.00
36F7Pj.........0.00............364A2W..........33.00
364A2W......-23.00..........36F7PJ............15.00
36IWSK.......-23.00..........36IWSK...........77.00

Example: What I want.
A..............B......................C............D
35MSS8.....11.00.............35MSS8.....36.00
37LYGU......10.................37LYGU......64.00
36OWZK.....0.00..............36OWZK.....43.00
36F7PJ........0.00..............36F7PJ.......15.00
364A2W.....-23.00............364A2W......33.00
36IWSK......-23.00............36IWSK.......77.00


If anyone can help me I would Greatly appreciate it! I need this bad I have searched everywhere and cant find a answer. Thank you in advance!