**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need help with Vlookup- am trying to copy a data from one sheet onto another matching the number but with a column

Solved by C. H. in 20 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
22/08/2018 - 06:22

Hello and Welcome to Got It Pro!

User
22/08/2018 - 06:23

Hello

Excelchat Expert
22/08/2018 - 06:23

I see you need assistance with a VLOOKUP. How can I help?

User
22/08/2018 - 06:24

If i need to copy the # of lates from sheet 1

User
22/08/2018 - 06:24

onto column E for sheet 2

User
22/08/2018 - 06:24

how do i do it?

Excelchat Expert
22/08/2018 - 06:25

Ok. I will write the formula on Sheet 2.

User
22/08/2018 - 06:26

my formula was =VLOOKUP(B13,'Full Listing'!A3:P211,3,FALSE)

Excelchat Expert
22/08/2018 - 06:27

You need to use absolute referencing so that the table reference doesn't change when you copy the formula down the sheet.

Excelchat Expert
22/08/2018 - 06:27

=VLOOKUP(B13,'Full Listing'!$A$3:$P$211,3,FALSE)

User
22/08/2018 - 06:28

=VLOOKUP(B13,'Full Listing'!$A$3:$P$211,3,FALSE)

User
22/08/2018 - 06:28

tjat

User
22/08/2018 - 06:29

that's what i put in, it still gives me an error

Excelchat Expert
22/08/2018 - 06:29

Can you share what is in 'Full Listing'!A3:P211?

User
22/08/2018 - 06:29

the employee number is there

Excelchat Expert
22/08/2018 - 06:30

B13 is the employee number also?

User
22/08/2018 - 06:30

in a different sheet

User
22/08/2018 - 06:30

Yes B13 is also ee number, in a different sheet

Excelchat Expert
22/08/2018 - 06:31

Is the employee number in column A of FUll Listing sheet?

User
22/08/2018 - 06:31

A3:P11 is ALL employee numbers in sheet 1 and B13 is an employee number in sheet 2 (which should match the employee number in sheet 1)

User
22/08/2018 - 06:31

Yes it is!

User
22/08/2018 - 06:32

but it's in column B in sheet 2

Excelchat Expert
22/08/2018 - 06:32

Ok. What error are you getting from the vlookup?

User
22/08/2018 - 06:32

#N/A

Excelchat Expert
22/08/2018 - 06:33

Ok. That means it is not locating that employee number in the table. Were you able to manually frind the employee number?

User
22/08/2018 - 06:33

yes

Excelchat Expert
22/08/2018 - 06:34

Ok. Sometimes a vlookup will give an error if the ee number is in the wrong format or has a space at the end.

Excelchat Expert
22/08/2018 - 06:34

Can you retype the employee number and see if it works?

User
22/08/2018 - 06:35

I just typed it in again and it still gives me the same error

Excelchat Expert
22/08/2018 - 06:35

Can you share the file so that I can take a look?

User
22/08/2018 - 06:36

Unfortunately it's confidential so I can't share the file

User
22/08/2018 - 06:36

what format should the employee number be in

Excelchat Expert
22/08/2018 - 06:36

Ok. Try to go to the table on Full Listing and type the ee number again.

Excelchat Expert
22/08/2018 - 06:36

It can be in any format as long as they match.

User
22/08/2018 - 06:37

just did that as well

User
22/08/2018 - 06:37

didn't work

Excelchat Expert
22/08/2018 - 06:38

Ok.

Excelchat Expert
22/08/2018 - 06:39

Try this. =VLOOKUP(trim(B13),'Full Listing'!$A$3:$P$211,3,FALSE)

Excelchat Expert
22/08/2018 - 06:39

Or this. =VLOOKUP(value(B13),'Full Listing'!$A$3:$P$211,3,FALSE)

User
22/08/2018 - 06:40

none of it worked

User
22/08/2018 - 06:40

thank you for your help

Excelchat Expert
22/08/2018 - 06:40

Sorry we couldn't figure it out.

Excelchat Expert
22/08/2018 - 06:41

Please click the Done button and leave feedback if you have time. Thanks.

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