Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 87
  • Last Modified:

vlookup workbook to workbook

Source: Workbook1
4648
4792
5025
5239
5861
6223
6772
7073
7091
7267
7271
7273
7297
7333 Hot
7350
7361 Cold

Target:  Workbook2

Find and return what is in Column B  in this case Hot and Cold

7333
7361

This must be a vlookup solution can some one help please thanks
0
brianpowell
Asked:
brianpowell
  • 4
1 Solution
 
Phillip BurtonCommented:
=VLOOKUP(A1,[Workbook1.xlsx]Sheet1!$A:$B,2,FALSE)
0
 
brianpowellAuthor Commented:
thanks
0
 
Hakan YılmazTechnical Office MEP EngineerCommented:
Using VLOOKUP between different worksheets may increase file size as much as the size of ranges you referenced.
You may uncheck the "Save external link values" setting in Excel Options to prevent his.
suggestionINDEX and MATCH combination will be better and usually faster in large workbooks.
For your case, this sense nothing. But if your original data is larger, you should consider.
=INDEX([Workbook1.xlsx]Sheet1!$B:$B,MATCH(A1,[Workbook1.xlsx]Sheet1!$A:$A,0))
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
brianpowellAuthor Commented:
Thanks for the added detail.

bp
0
 
brianpowellAuthor Commented:
8 thousand records over 100 fields.
0
 
brianpowellAuthor Commented:
sorry for being late.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now