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.
