**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.*