Hello all:

I have a list of accounts that are downloaded to excel once a month. I then
need to reorder these accounts to group them according to client (as opposed
to how they come in # order) I have set the order that I need and would like
to be able to match the new information received to the order I prefer.

ex)

column A is the order I want. Columns B,C,D is the information I need to
re-sort

A B C D
1 p123 n452 client E $40.00
2 n452 v685 client C $135.00
3 r269 d863 client A $25.00
4 d863 p123 client B $82.00
5 v685 r269 clientd $75.00

I would like it to match column A like so:

A B C D
1 p123 p123 client B $82.00
2 n452 n452 client E $40.00
3 r269 r269 clientd $75.00
4 d863 d863 client A $25.00
5 v685 v685 client C $135.00

Is this possible in excel. Any help would be greatly appreciated.

Thanks
jw