[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 88
  • 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 BurtonDirector, Practice Manager and Computing ConsultantCommented:
=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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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