The simplest form of this is to open both workbooks, click the cell you want the data in, enter = then click the cell the data is in on the other workbook. Excel will link to the file path, you have to close the source workbook to see this. If needed you can edit this formula to use your lookup columns.
It will look something like this
='C:\data\files\[Master samples.xlsx]Sheet1'!$C$14
|