intersection of two tabs in excel
 

Hi - I have sampled some data in excel and I have come up with a sample of
155 data points I want to copy into another tab from a sample size of 2435.
I have a number that is unique on both workseets. I could do a find on each
one than copy and paste to a new workseet. There must be an easier way, is
it a vlookup function?

Help

intersection of two tabs in excel
 

Yes. If you have 2 columns of data in your database, and you want info from
2nd column, put this in B column next to your list of 155 points.
=VLOOKUP(A2,ReferenceToOtherDatabase,2,FALSE)

Easiest way to get the reference is, while editing formula, select the area
of the database. Hope this answers your question.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"betsy" wrote:

Hi - I have sampled some data in excel and I have come up with a sample of
155 data points I want to copy into another tab from a sample size of 2435.
I have a number that is unique on both workseets. I could do a find on each
one than copy and paste to a new workseet. There must be an easier way, is
it a vlookup function?

Help

intersection of two tabs in excel
 

Thanks my issue is I want to copy all columns of data a - e from the
referencetootherdata next to A2 not just one column.

Thanks.

"Luke M" wrote:

Yes. If you have 2 columns of data in your database, and you want info from
2nd column, put this in B column next to your list of 155 points.
=VLOOKUP(A2,ReferenceToOtherDatabase,2,FALSE)

Easiest way to get the reference is, while editing formula, select the area
of the database. Hope this answers your question.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"betsy" wrote:

Hi - I have sampled some data in excel and I have come up with a sample of
155 data points I want to copy into another tab from a sample size of 2435.
I have a number that is unique on both workseets. I could do a find on each
one than copy and paste to a new workseet. There must be an easier way, is
it a vlookup function?

Help

intersection of two tabs in excel
 

Hi,

You could possibly use Advanced Filters. They are well explained in the
Help menu.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"betsy" wrote in message
...
Hi - I have sampled some data in excel and I have come up with a sample of
155 data points I want to copy into another tab from a sample size of
2435.
I have a number that is unique on both workseets. I could do a find on
each
one than copy and paste to a new workseet. There must be an easier way,
is
it a vlookup function?

Help