Question description:
This user has given permission to use the problem statement for this
blog.
My vlookup is not pulling in all data, i need help as to why it's displaying errors
Solved by B. D. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
18/09/2018 - 01:34
Hello
Excelchat Expert
18/09/2018 - 01:35
Welcome to Excelchat, I see that your question is about Vlookup
Excelchat Expert
18/09/2018 - 01:35
I can help you with that problem.
User
18/09/2018 - 01:35
Hello
Excelchat Expert
18/09/2018 - 01:35
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User
18/09/2018 - 01:35
Let me set my data for you
User
18/09/2018 - 01:35
Perfect
Excelchat Expert
18/09/2018 - 01:35
Sure, please do.
Excelchat Expert
18/09/2018 - 01:36
I will wait for the data and then ask any question I have before we proceed further.
User
18/09/2018 - 01:37
so when i performed a vlookup from sheet 2 to 1
User
18/09/2018 - 01:37
I get errors on some cells
Excelchat Expert
18/09/2018 - 01:37
Ok.
User
18/09/2018 - 01:37
I need date from sheet 1 to be populated in sheet 2
Excelchat Expert
18/09/2018 - 01:38
Please allow me a minute to generate the formula and then we will see why we are getting these errors.
Excelchat Expert
18/09/2018 - 01:38
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
18/09/2018 - 01:39
So all the N/A are where Vlookup is unable to find any match in sheet 1
User
18/09/2018 - 01:39
A10 in sheet 1 is the value of the first error
Excelchat Expert
18/09/2018 - 01:40
Ok. Let me check this.
Excelchat Expert
18/09/2018 - 01:42
I’m working on your solution. But don’t worry, I’ll be updating you throughout!
Excelchat Expert
18/09/2018 - 01:44
I am still working on it, please allow me few minutes
User
18/09/2018 - 01:45
ok
User
18/09/2018 - 01:47
thank you we found the error
Excelchat Expert
18/09/2018 - 01:48
The error is with the 255 character
User
18/09/2018 - 01:48
looks like there are formatting differences
Excelchat Expert
18/09/2018 - 01:48
the work around is Index Match in an array formula
Excelchat Expert
18/09/2018 - 01:48
Did it work after changing the formatting?
User
18/09/2018 - 01:48
i dont know how to do that
User
18/09/2018 - 01:49
is there an easy way?
Excelchat Expert
18/09/2018 - 01:49
I already did the formatting trouble shoot but still not working.
Excelchat Expert
18/09/2018 - 01:49
Give me minute
User
18/09/2018 - 01:49
thank you!
Excelchat Expert
18/09/2018 - 01:52
It is still not working on the way around.
Excelchat Expert
18/09/2018 - 01:52
I am still looking deeper now to find the problem.
Excelchat Expert
18/09/2018 - 01:52
Please extend the session, if prompted to.
Excelchat Expert
18/09/2018 - 01:53
The formula is working fine.
Excelchat Expert
18/09/2018 - 01:53
The problem is the text
Excelchat Expert
18/09/2018 - 01:53
like , is missing in A10 on sheet 1
Excelchat Expert
18/09/2018 - 01:53
"Hey all,"
Excelchat Expert
18/09/2018 - 01:54
I hope I am making sense.
Excelchat Expert
18/09/2018 - 01:54
Are you still ther?
Excelchat Expert
18/09/2018 - 01:54
Please respond.
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.