Question description:
This user has given permission to use the problem statement for this
blog.
Hi, my VLOOKUP isn't working. No matter what I do it is returning the same result regardless of the sku it is searching for - even if I copy and paste the sky into the sheet the exact same way it is typed in the sheet its searching
Solved by X. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/03/2018 - 12:38
Hi
Excelchat Expert
30/03/2018 - 12:38
Welcome to got it pro
Excelchat Expert
30/03/2018 - 12:39
do you have some sample data so that i can see where you are stuck
Excelchat Expert
30/03/2018 - 12:41
are you there?
Excelchat Expert
30/03/2018 - 12:44
Hey
Excelchat Expert
30/03/2018 - 12:44
you there?
User
30/03/2018 - 12:45
so sorry! I was so engrossed in my work I forgot about this, I worked it out now, I stupidly hadn't converted to numbers on the cell I was looking up
Excelchat Expert
30/03/2018 - 12:45
ohk
User
30/03/2018 - 12:45
so so so sorry!
User
30/03/2018 - 12:45
but thanks anyway :)
Excelchat Expert
30/03/2018 - 12:45
meanwhile i have also demonstrated on spread sheet
Excelchat Expert
30/03/2018 - 12:45
no problem
Excelchat Expert
30/03/2018 - 12:46
Please do give good rating
Excelchat Expert
30/03/2018 - 12:46
it would really help
Excelchat Expert
30/03/2018 - 12:46
i would have loved to helped you
Excelchat Expert
30/03/2018 - 12:46
but you figured out
Excelchat Expert
30/03/2018 - 12:46
:)
Excelchat Expert
30/03/2018 - 12:46
please do give good rating once you end the session
Excelchat Expert
30/03/2018 - 12:47
when you are using vlookup make sure things are in same format..so that helps a lot
User
30/03/2018 - 12:47
yes I will for sure, and yes that was the issue, I think i've gone cross eyed from looking at it haha!
Excelchat Expert
30/03/2018 - 12:48
haha
Excelchat Expert
30/03/2018 - 12:48
take care buddy
Excelchat Expert
30/03/2018 - 12:49
you can end the session :)
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.
