**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.*