|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.