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