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?
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?