Combining Sheets

E

esquire808

Hello,

I am curious if it is possible to combine two different sheets both
have one common column.

here is what i would like to see happen *note C3 is the same on both
sheets*

A1 B2 C3 D4 & A1 B2 C3 D4

into

A1 B2 C3 D4 E4 F4 G4 H4


*shrug*

Thanks for any input


CB :confused:
 
O

Otto Moehrbach

I'm sure that what you want can be done. However, what you posted is not
enough to tell me what you want. Post back and state clearly what is on one
sheet and what is on the other sheet. Then state clearly what you want to
happen on what sheet. HTH Otto
 
E

esquire808

ok, here goes nothing

Sheet #1

A1 B1
Address Name
______________
Blah1 Blah#
Blah2 Blah#
Blah3 Blah#

Sheet #2
A1 B1
D.O.B Address

______________
Blah9 Blah1
Blah8 Blah2
Blah7 Blah3


So my goal is combining both sheets 1 & 2 using one common column t
make a new sheet


Sheet #3
A1 B1 C1
Name Address D.O.B

________________________________________________
Blah# Blah1 Blah9
Blah# Blah2 Blah8
Blah# Blah3 Blah7



Hope this helps :
 
T

Tamale

are they in the same order on both sheets or do you need this to be
intelligent?

if they're in the same order, just copy and paste by entire columns and
that should get what you want.. ?
 
M

Max

One way ..

Assuming the source tables as shown are
in Sheet1 and Sheet2, data from row2 down

In Sheet3
-------
Assume col B contains:

Address
Blah1
Blah2
Blah3
etc

where data is from row2 down, i.e. in B2 down
and labels "Name" and "DOB" are in A1 and C1

Put in A2: =INDEX(Sheet1!B:B,MATCH(B2,Sheet1!A:A,0))
Copy down

Put in C2: =INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0))
Copy down

Or perhaps better with error-trapping
to return blanks: "" for unmatched cases:

Put in A2:
=IF(ISNA(MATCH(B2,Sheet1!A:A,0)),"",
INDEX(Sheet1!B:B,MATCH(B2,Sheet1!A:A,0)))

Put in C2:
=IF(ISNA(MATCH(B2,Sheet2!B:B,0)),"",
INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0)))

Copy down cols A and C as before
 
E

esquire808

Hmm.

I was hoping that I could get it to match the data for me. If that dat
was indeed the same in on both sheets then would compile them into on
big sheet. Directions of that last post left me somewhat more in th
dark

Sorry im a noob :
 
M

Max

.. Directions of that last post left me somewhat more in the dark

urrgh .. the specifics in the response weren't sufficient ? Your 2nd post
illustrated a common key field in Sheets 1 & 2 (Address) which was then used
in Sheet3 to pull in matching data from Sheets 1 and 2. Post a link to your
sample file
 
E

esquire808

I don't have the ability to post things. I took some screenshots. Coul
I email them to ya
 
E

esquire808

Max,

That was exactly what I needed to accomplish! I very much appreciate
the fact you took the time to help me via email as I was unable to
upload my files and not to mention I am a very inexperienced excel user
in comparison to your expertise.

Thank you

P.S
Thanks to those who run this forum as it has proved to be an invaluable
resource to the Excel users community.


CB
 
Top