Question description:
This user has given permission to use the problem statement for this
blog.
I am getting an N/A from a vlookup formula and cannot figure out why
Solved by C. U. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/03/2018 - 06:57
Hi...Welcome to Got it pro
User
22/03/2018 - 06:57
hello
Excelchat Expert
22/03/2018 - 06:57
can you share your data?
Excelchat Expert
22/03/2018 - 06:57
so that i can see how you are getting the error
User
22/03/2018 - 06:58
yes
User
22/03/2018 - 06:58
hang on please
Excelchat Expert
22/03/2018 - 06:58
thanks
User
22/03/2018 - 07:01
ok
User
22/03/2018 - 07:01
I am trying to create a vlookup to link the first and last names with the serial numbers
Excelchat Expert
22/03/2018 - 07:02
which cell you are doing the vlookup formula?
User
22/03/2018 - 07:02
sheet 2, b column
Excelchat Expert
22/03/2018 - 07:02
ok i am looking at it
Excelchat Expert
22/03/2018 - 07:03
so you are looking up the number to fetch first and last name, is that correct?
User
22/03/2018 - 07:04
yes. I would like to pull the first and last names from sheet 1, and match them to their corresponding numbers on sheet 2
Excelchat Expert
22/03/2018 - 07:04
For Vlookup your lookup array has to be in the first column
Excelchat Expert
22/03/2018 - 07:04
So your serial number should be ideally in Column A in sheet 1
Excelchat Expert
22/03/2018 - 07:05
else you can't use vlookup
Excelchat Expert
22/03/2018 - 07:05
but there is another advanced look up formula which can fetch the results without any condition that vlookup has
Excelchat Expert
22/03/2018 - 07:05
let me show you that
Excelchat Expert
22/03/2018 - 07:06
or do you want to still use vlookup by moving serial numbers to the first column?
User
22/03/2018 - 07:06
we can move the numbers
Excelchat Expert
22/03/2018 - 07:06
ok
Excelchat Expert
22/03/2018 - 07:06
i will do the formula in B1
User
22/03/2018 - 07:07
ok
Excelchat Expert
22/03/2018 - 07:08
Please have a look
Excelchat Expert
22/03/2018 - 07:08
Does that work now?
User
22/03/2018 - 07:08
it only pulled the same names. they are all lara or lebowitz
Excelchat Expert
22/03/2018 - 07:10
yes i see that
Excelchat Expert
22/03/2018 - 07:10
hold on
Excelchat Expert
22/03/2018 - 07:12
Is it ok now?
User
22/03/2018 - 07:12
yes
User
22/03/2018 - 07:12
!
User
22/03/2018 - 07:13
Thank you!
Excelchat Expert
22/03/2018 - 07:13
Great...please rate me if I have sucessfully solved your query.
Excelchat Expert
22/03/2018 - 07:13
Thanks for your time. Please do come back for any new question. Have a great day ahead!
User
22/03/2018 - 07:13
can I download this?
Excelchat Expert
22/03/2018 - 07:13
yes please
User
22/03/2018 - 07:13
thank you very much
Excelchat Expert
22/03/2018 - 07:14
you are welcome
User
22/03/2018 - 07:14
where can I rate you
Excelchat Expert
22/03/2018 - 07:14
it will prompt you while exiting this 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.