Excel - Help on VLOOKUP Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.