Question description:
This user has given permission to use the problem statement for this
blog.
I need Vlookup help across 2 workbooks into one other main workbook and can't figure out what i'm doing wrong!
Solved by G. E. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
03/08/2018 - 10:08
Hello
User
03/08/2018 - 10:09
Hi :) I need to write a vlookup to cross reference 2 columns from one workbook with one column on another and provide a match
Excelchat Expert
03/08/2018 - 10:10
Is it possible for you to share the sheet?
Excelchat Expert
03/08/2018 - 10:11
Are you still there?
User
03/08/2018 - 10:12
give me 2 seconds and i'll upload it
Excelchat Expert
03/08/2018 - 10:12
Ok
User
03/08/2018 - 10:16
So I need to find out the lease end date from book 2 for all serial numbers in book 1
[Uploaded an Excel file]
User
03/08/2018 - 10:16
[Uploaded an Excel file]
Excelchat Expert
03/08/2018 - 10:18
Please go to book 1
User
03/08/2018 - 10:18
yes
Excelchat Expert
03/08/2018 - 10:18
since it is a vlookup between 2 files so we have to define the path on your computer
Excelchat Expert
03/08/2018 - 10:19
I will tell you how to write the formula and you do it.
Excelchat Expert
03/08/2018 - 10:19
would that be fine?
User
03/08/2018 - 10:19
thanks
Excelchat Expert
03/08/2018 - 10:19
Click on cell B2
Excelchat Expert
03/08/2018 - 10:19
FIRST CELL WHERE WE NEED FORMULA
Excelchat Expert
03/08/2018 - 10:19
=VLOOKUP(A2,
Excelchat Expert
03/08/2018 - 10:19
and type this.
User
03/08/2018 - 10:20
ok
Excelchat Expert
03/08/2018 - 10:20
after typing this goto book2 and click on A on the top - keeping mouse pressed select B also
Excelchat Expert
03/08/2018 - 10:21
basically we are selecting both the columns.
Excelchat Expert
03/08/2018 - 10:21
then type
Excelchat Expert
03/08/2018 - 10:21
,2,false) and press enter
Excelchat Expert
03/08/2018 - 10:22
?are you with me on this
User
03/08/2018 - 10:22
when I go to the next sheet and try to select the first cell it tells me i've entered too few arguments
Excelchat Expert
03/08/2018 - 10:22
Ok.
Excelchat Expert
03/08/2018 - 10:22
press escape
Excelchat Expert
03/08/2018 - 10:22
go on book 1
User
03/08/2018 - 10:24
ok i'm starting again
Excelchat Expert
03/08/2018 - 10:24
Try this
[Uploaded an Excel file]
Excelchat Expert
03/08/2018 - 10:24
I have put the formula.
User
03/08/2018 - 10:24
thank you!
Excelchat Expert
03/08/2018 - 10:25
Is it working?
Excelchat Expert
03/08/2018 - 10:26
if it is showing 0 that means, it has found the match but the return cell is empty
User
03/08/2018 - 10:26
just trying now
Excelchat Expert
03/08/2018 - 10:26
if it is showing #n/a means it didnot find the match
Excelchat Expert
03/08/2018 - 10:26
please extend the session so that I can explain the formula.
Excelchat Expert
03/08/2018 - 10:26
=VLOOKUP(A2,[Book2.xlsx]Sheet1!$A:$B,2,FALSE)
User
03/08/2018 - 10:27
that's perfect thank you!
Excelchat Expert
03/08/2018 - 10:27
Great
Excelchat Expert
03/08/2018 - 10:27
Do you need help understanding the formula.
User
03/08/2018 - 10:27
I think I have it
User
03/08/2018 - 10:27
thank you!
Excelchat Expert
03/08/2018 - 10:27
Please do provide good feedback.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.