# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have an excel spreadsheet with two worksheets. And the following formula is not pulling the data. =VLOOKUP(\$A\$2:\$A\$566,'Module Type Info'!\$A\$2:\$D\$97,4,FALSE) In sheet 1, I am using all data in column 1 for the lookup In sheet 2, I have selected the first 4 columns of data for array I want to pull data from sheet 2, column 4 into sheet 1 Both tabs are sorted alphabetically. Confirmed that the value in column 4 of sheet 2 is a TEXT field. Why is this not pulling the info from sheet 2 into sheet 1
Solved by F. L. in 39 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/09/2018 - 02:23
Welcome, Thanks for choosing Got It Pro-Excel. I can help you with that problem.
Excelchat Expert 20/09/2018 - 02:23
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert 20/09/2018 - 02:23
Do you have sample data which we can use to illustrate how to solve this problem?
User 20/09/2018 - 02:23
Sure
Excelchat Expert 20/09/2018 - 02:26
Let me know once you are done please.
User 20/09/2018 - 02:27
ok dibe
User 20/09/2018 - 02:27
done
Excelchat Expert 20/09/2018 - 02:28
Okay.
Excelchat Expert 20/09/2018 - 02:28
In sheet2, Org is in which column?
User 20/09/2018 - 02:28
1
Excelchat Expert 20/09/2018 - 02:29
Very good.
Excelchat Expert 20/09/2018 - 02:29
Based on what you’ve shared, you need a VLOOKUP formula which will return the corresponding value of the Org.
Excelchat Expert 20/09/2018 - 02:29
User 20/09/2018 - 02:30
yes, that is what I want. Match the org in both sheets and then retrieve data from column 4 sheet 2 into sheet 1
Excelchat Expert 20/09/2018 - 02:30
I am creating a formula that will solve this problem. Will get back to you shortly.
Excelchat Expert 20/09/2018 - 02:33
Excelchat Expert 20/09/2018 - 02:33
The formula that we can use is:
Excelchat Expert 20/09/2018 - 02:33
=VLOOKUP(A2,Sheet2!\$A\$1:\$D\$96,4,FALSE)
Excelchat Expert 20/09/2018 - 02:33
I have already applied it in cell B2
Excelchat Expert 20/09/2018 - 02:34
The values for which #N/A is returned, it simply means that they could not be found in sheet2's column A.
Excelchat Expert 20/09/2018 - 02:35
Are you there?
User 20/09/2018 - 02:35
Yes
User 20/09/2018 - 02:36
I am trying to get that formula to work but it's not in my spreadsheet
Excelchat Expert 20/09/2018 - 02:36
User 20/09/2018 - 02:36
User 20/09/2018 - 02:37
For the "A2" is that A2 in sheet 1 or sheet 2
Excelchat Expert 20/09/2018 - 02:37
A2 is in sheet1
Excelchat Expert 20/09/2018 - 02:37
Currently it is referring to "1ffc"
User 20/09/2018 - 02:39
=VLOOKUP(A2,'Module Type Info'!\$A\$2:\$D\$97,4,FALSE)
User 20/09/2018 - 02:39
that is my formula in my spreadsheet and it is returning all #N/A
User 20/09/2018 - 02:40
I have to run for 10 mintues. I will be right back.
Excelchat Expert 20/09/2018 - 02:40
Will you mind sharing the actual file?
Excelchat Expert 20/09/2018 - 02:40
Okay.
User 20/09/2018 - 02:51
I am back
Excelchat Expert 20/09/2018 - 02:51
Okay.
Excelchat Expert 20/09/2018 - 02:51
Will you mind sharing the actual file?
User 20/09/2018 - 02:52
Let me clear out some data and then I will send
User 20/09/2018 - 02:52
Give me just a minute
Excelchat Expert 20/09/2018 - 02:52
Okay.
User 20/09/2018 - 02:55
Excelchat Expert 20/09/2018 - 02:59
Yeah,
Excelchat Expert 20/09/2018 - 02:59
I have confirmed.
Excelchat Expert 20/09/2018 - 02:59
The formula is okay.
Excelchat Expert 20/09/2018 - 03:00
But there is no single value in column A which appears in sheet2
Excelchat Expert 20/09/2018 - 03:00
That is why we have #N/A
Excelchat Expert 20/09/2018 - 03:00
To all of them.
Excelchat Expert 20/09/2018 - 03:00
Kindly accept the free time extension.
Excelchat Expert 20/09/2018 - 03:01
So that we can be in a position to chat.
Excelchat Expert 20/09/2018 - 03:02
Check the count function.
Excelchat Expert 20/09/2018 - 03:02
It returns all zeros.
Excelchat Expert 20/09/2018 - 03:02
I see time is up.

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.