All solutions FormulaVLOOKUP Expert Solution – How to Use a VLOOKUP Formula

Excel - How to Use a VLOOKUP Formula - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc