Excel - Help on VLOOKUP Problem - Expert Solution

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.

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.