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.