Excel - COLUMN Function Problem - Expert Solution

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

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
The Allstate Corporation
United Parcel Service
Dell Inc