Arif_Tamboli
New Member
- Joined
- Mar 1, 2018
- Messages
- 34
- Office Version
- 2016
how to coad vlookup with different workbook
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
how to coad do vlookup with different workbook
- Thread starter Arif_Tamboli
- Start date
Excel Facts
Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
In the range where it looks vlookup, put the complete path to the file and the filename.
Try it like this:
in the file where you want to see the result, put the formula and when you reach the range, click in the other file and select the desired range. You will see that the formula adjusts and the full path in the formula will appear, then write the column and the type of search.
Try it like this:
in the file where you want to see the result, put the formula and when you reach the range, click in the other file and select the desired range. You will see that the formula adjusts and the full path in the formula will appear, then write the column and the type of search.
Upvote
0
Similar threads
- Solved
- Replies
- 2
- Views
- 494
- Replies
- 1
- Views
- 231
- Replies
- 2
- Views
- 297
- Replies
- 2
- Views
- 127
