intersection of two tabs in excel

B

betsy

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
 
L

Luke M

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

betsy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need an aswer- URGENT! 2
Can you automatically filter for unique records? 3
Can a row containing protected & unprotected cells be copied? 8
Consolidate two Data Sets for Making a Report 1
intersection of two lines defined by points 7
Finding Intersection Points between different lines 1
vlookup Function Help Needed 4
Access Sequentially numbered column that resets with each new sample 0

Top