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
Do you believe that will address your problem?
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
Thank you for your patience.
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
What do you mean that it is not in your spreadsheet?
User
20/09/2018 - 02:36
not working in my spreadsheet.
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
Here is the spreadsheet
[Uploaded an Excel file]
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.
[Uploaded an Excel file]
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.