Question description:
This user has given permission to use the problem statement for this
blog.
I am trying to do a VLOOKUP, the formula seems correct to me, the value I am looking for is in the Table Array, but I get an #N/A result
Solved by A. U. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/04/2018 - 12:00
Thanks for using Got It Pro. ’d love to help you with your problem if you would kindly give me more information.
User
20/04/2018 - 12:00
Okay hold on making a facsimile of the problem
User
20/04/2018 - 12:00
The file is way too big to upload it all
Excelchat Expert
20/04/2018 - 12:00
ok sure
User
20/04/2018 - 12:02
Okay, why is my VLOOKUP not working?
Excelchat Expert
20/04/2018 - 12:02
ok let me check
User
20/04/2018 - 12:02
I am telling it to lookup 154713 in sheet 2, column 3, and 154713 is there.
Excelchat Expert
20/04/2018 - 12:03
ok checking
User
20/04/2018 - 12:03
Is it because the value in sheet 2, column 3 is the same as the value I am asking it to look up in sheet 1?
Excelchat Expert
20/04/2018 - 12:04
No check it's working now
Excelchat Expert
20/04/2018 - 12:04
I am explaining
Excelchat Expert
20/04/2018 - 12:05
You are searching for value 154713, this value available on Column C 2nd sheet
Excelchat Expert
20/04/2018 - 12:05
SO Column c should be 1st array
Excelchat Expert
20/04/2018 - 12:06
Is there anything else you want to know regarding this issue?
User
20/04/2018 - 12:06
Oh the column with the value I am seeking has to be the 1st column in the array (range)? Okay that was not clear in any of the how-to's on VLOOKUP. Thanks!
Excelchat Expert
20/04/2018 - 12:06
yes right
User
20/04/2018 - 12:06
That is all. Goodbye!
Excelchat Expert
20/04/2018 - 12:06
Thanks for using Got It Pro. Please give your kind feedback for our service.Have a good day ahead.
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.
