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
LVL 1
brianpowellAsked:
Who is Participating?
 
Phillip BurtonConnect With a Mentor Director, 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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.