**Question description:**

*This user has given permission to use the problem statement for this blog.*

Please help me to use vlookup when serial # isn't on far left

Solved by V. C. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
11/05/2018 - 04:54

Hi how are you

Excelchat Expert
11/05/2018 - 04:54

Hi

Excelchat Expert
11/05/2018 - 04:54

Welcome to Got it Pro

Excelchat Expert
11/05/2018 - 04:54

Please elaborate more on your requirement so that i can help you better

User
11/05/2018 - 04:55

Can you see the google sheets

Excelchat Expert
11/05/2018 - 04:55

yes

Excelchat Expert
11/05/2018 - 04:56

Please tell

User
11/05/2018 - 04:56

Invoice upload draws info from two sheets

User
11/05/2018 - 04:56

I need to make sure the serial numbers match before I pull the corresponding value for each column

User
11/05/2018 - 04:56

do you understand?

Excelchat Expert
11/05/2018 - 04:56

yes

User
11/05/2018 - 04:57

for example on invoice upload sheet

User
11/05/2018 - 04:57

h10

User
11/05/2018 - 04:57

I would like to take the matching serial # from data 1 and 2 and find in data 2 the invoice end date

User
11/05/2018 - 04:57

how do i do this

Excelchat Expert
11/05/2018 - 04:58

you can match this in either of the sheet and then place a matching value

User
11/05/2018 - 04:58

whats' the formula

Excelchat Expert
11/05/2018 - 04:58

=VLOOKUP(C10,Sheet2!$M:$P,4,0)

Excelchat Expert
11/05/2018 - 04:59

This is the formula

Excelchat Expert
11/05/2018 - 04:59

See H10

Excelchat Expert
11/05/2018 - 04:59

Do you see?

Excelchat Expert
11/05/2018 - 05:01

Are you there?

Excelchat Expert
11/05/2018 - 05:01

Please see H10 in Invoice Upload

Excelchat Expert
11/05/2018 - 05:01

I have put the formula

Excelchat Expert
11/05/2018 - 05:01

=VLOOKUP(C10,Sheet2!$M:$P,4,0)

Excelchat Expert
11/05/2018 - 05:02

Let me know if that helps

User
11/05/2018 - 05:02

one sec

User
11/05/2018 - 05:02

you rock

Excelchat Expert
11/05/2018 - 05:02

Thanks

Excelchat Expert
11/05/2018 - 05:02

Please do give good rating and reviews

Excelchat Expert
11/05/2018 - 05:02

It really helps

User
11/05/2018 - 05:03

how do i contact you

User
11/05/2018 - 05:03

elmcitycm@gmail.com

User
11/05/2018 - 05:03

elmcitycm at gmail dot com

User
11/05/2018 - 05:03

be in touch

Excelchat Expert
11/05/2018 - 05:04

You can post questions on got it pro and a tutot will get in contact with you

User
11/05/2018 - 05:04

i want you

User
11/05/2018 - 05:04

In AMERICA

Excelchat Expert
11/05/2018 - 05:04

You can provide your rating here once you end the session

User
11/05/2018 - 05:04

contact me

Excelchat Expert
11/05/2018 - 05:05

As a policy here we are not allowed to share email ids

Excelchat Expert
11/05/2018 - 05:05

Hope you understand

User
11/05/2018 - 05:05

i figured as much

User
11/05/2018 - 05:05

that's why i sent you mine

User
11/05/2018 - 05:05

remember or write it down

Excelchat Expert
11/05/2018 - 05:06

Please dont forget to give your ratings

Excelchat Expert
11/05/2018 - 05:06

It really helps

User
11/05/2018 - 05:06

will do

Excelchat Expert
11/05/2018 - 05:06

Thanks

Excelchat Expert
11/05/2018 - 05:06

Have a great day

User
11/05/2018 - 05:06

you too

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