VLOOKUP AND ARRAY

[WiscCard]

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?

 

[texasalynn]

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]

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]

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