intersection of two tabs in excel

  • Thread starter Thread starter betsy
  • Start date Start date
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
 
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.
 
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.
 
Back
Top