Both workbooks are saved in the same directory.

Vlookup between 2 workbooks. We have three pieces of. Open any one of the two ms excel files. And suppose we have another workbook called data2.xlsx:

Close all excel files and shut down ms excel. Then create the vlookup formula, click one cell where you want to put the result, and then click formulas >. Create list of multiple different workbooks.

=vlookup(the formula guide will appear below. Vlookup from a different workbook. Click kutools > select > select same & different cells, see screenshot:

Assign the formula =vlookup (b5, [prices.xlsx]sheet1!a2:b6,2,false). You may notice excel displays the formula in 2 places: Press ctrl+o and select the other excel files from the file open box.

Now, we have divided the data into multiple worksheets. Press enter to apply it to f5. Open both workbooks that you want to vlookup from one to another.

I will open both of my workbooks when running the vba codes, and i saved both workbooks as.xlsm so they are both macro. In the select same & different cells dialog box, do the following operations: From data workbook, i am fetching the data to result workbook.