M--Personal-ee---VLOOKUP-2sheets.xlsx

<div>
glad it seemed to work out for you! Ta, Danny
</div>


glad it seemed to work out for you! Ta, Danny

<div>
<div class="content wysiwyg-content">
Need help with using a vlookup to combine two EXCEL files. &nbsp;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. &nbsp;<br />
<br />
EXCEL 1 - this master spreadsheet containing these columns:<br />
<br />
ID &nbsp; &nbsp; &nbsp; Name &nbsp; &nbsp;FileDate<br />
xxxx &nbsp; xxxxx &nbsp; &nbsp; xxxxx<br />
<br />
EXCEL 2 - this contains additional columns that I need to insert in EXCEL 1. &nbsp;<br />
<br />
ID &nbsp; &nbsp; &nbsp; Order Date &nbsp; Order Nbr<br />
xxxx &nbsp; xxxxxxx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXXX<br />
<br />
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. &nbsp;The ID column can be used as the KEY to linking the two files. &nbsp;The expected results would be like this:<br />
<br />
ID &nbsp; &nbsp; &nbsp; Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Order Date &nbsp; Order Nbr &nbsp;FileDate<br />
xxxx &nbsp; xxxxx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; xxxxxxx &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;XXXXXX &nbsp; &nbsp;xxxxxx
</div>
</div>


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

EXCEL - vlookup question

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.