Solved Move a cell and contents next to it's duplicate

October 24, 2014 at 18:09:25
Specs: Windows 7
I have a Column (column A) with invoice numbers (123456) that have the corresponding payment type (text) in the column next to it(Column B).

I need to move both the invoice number from column A and it's corresponding payment type from column B and next to the matching invoice number in Column C.


Match Column A to Column C and move cell from Column A (invoice number) and corresponding cell from Column C(payment type) next to the matching Invoice number in Column C

See More: Move a cell and contents next to its duplicate

Report •

October 24, 2014 at 18:38:31
✔ Best Answer
While I'm not sure why you need duplicate invoices numbers sitting next to each other, VLOOKUP sounds like it will work for you. Let's say you have invoice data in C2:C50.

Note: this is untested since I don't have access to Excel right now.

For the invoice numbers, put this in D2 and drag it down to D50:


For the payment types, put this in E2 and drag it down to E50:


For info on VLOOKUP, do a Google search. Here is just one hit.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question