# VLOOKUP AND ARRAY

#### WiscCard

##### New Member
I have searched the boards regaring what I believe I need, but am still running into trouble when trying to incorporate my names.
I know what I am trying to do would work in Access, but my data is too large to import as table to run a query.
I have Sheet 1 that contains the name and address of 65 thousand customers. Column A has the name and columns B-I have address date I need.
Now, I have Sheet 2 that just contains the names of 318 customers. I know those 318 customers are in Sheet 1. I run a vlookup comparing the names in Columns A and that tells me they match.
What I need is that if the vlookup returns a value (other than the #n/a) that it then put in the next columns the address information from sheet 1.
Is this possible?

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### texasalynn

##### Well-known Member
not sure I understand, but aren't you just wanting to return a certain column where the data matches?

=vlookup(a2,Sheet1!A2:I2000,3,false)
so this will return data from column C

if not could you post a small sample of your data with Colo utility found at the bottom of this post.

#### WiscCard

##### New Member
The vlookup I have run tells me what matches:
=VLOOKUP(A2,Sheet1!\$A\$2:\$A\$65536,1,FALSE)
What I need is that if that returns a value (ie finds that name) that it then return in the sheet 2 columns all the date from Sheet 1 row columns B-I.
Sorry, I am having trouble getting Colo to work while I am at work.

#### texasalynn

##### Well-known Member
create a vlookup for each of those columns and use this
=VLOOKUP(\$A2,Sheet1!\$A\$2:\$A\$65536,column(b\$2),FALSE)
so this you would put in column B, then copy across through column I and it will bring back the other columns of data

Replies
4
Views
158
Replies
0
Views
293
Replies
6
Views
221
Replies
0
Views
189
Replies
3
Views
348

1,191,275
Messages
5,985,707
Members
439,975
Latest member
eelyn

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back