Need help with using a vlookup to combine two EXCEL files. I just need to merge a couple of columns from a second EXCEL file but need these columns inserted after a specific column in the EXCEL master.
EXCEL 1 - this master spreadsheet containing these columns:
ID Name FileDate
xxxx xxxxx xxxxx
EXCEL 2 - this contains additional columns that I need to insert in EXCEL 1.
ID Order Date Order Nbr
xxxx xxxxxxx XXXXXX
I need to merge the Order Date and Order Nbr columns from EXCEL 2 into EXCEL 1 and I need to place them after the Name column. The ID column can be used as the KEY to linking the two files. The expected results would be like this:
ID Name Order Date Order Nbr FileDate
xxxx xxxxx xxxxxxx XXXXXX xxxxxx