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.

example:

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

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:

=VLOOKUP(C2,$A$2:$B$50,1,0)

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

=VLOOKUP(C2,$A$2:$B$50,2,0)

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

http://office.microsoft.com/en-us/e...

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

Ask Your Question

Weekly Poll