How do I combine two worksheets in EXCEL 2003

[Robert Judge]

I have two worksheets.

One contains the columns of Name, Birthday, and Phone.

The second one contains the columns of Name and Anniversary.

I want to combine the two worksheets into one worksheet that would include
all the columns, that is:

Name
Birthday
Anniversary
Phone

How can I accomplish this? I will appreciate advice.

 

[akphidelt]

You can do a vlookup in the 4th column on the 1st worksheet

So it would be

Vlookup(Name,2ndWorksheet!Range,2,False)

So for an example if the first name is in cell A2 on the 1st sheet
And the 2nd sheet has Names starting in A2 and ending A100 with the
Anniversary in column B.

The formula would like this. You put this formula wherever you want the
anniversary to show up

Vlookup(A2,'Sheet2'!A2:B100,2,False)

And then copy and paste this formula down to wherever your last row of data
is.

 

[Robert Judge]

Hi:

Thanks. But the formula I am entering is producing an error message:
#NA

In my original post, I deliberately made the column names I provided
different and I thought, simpler than they really are. I thought that might
help someone to provide an answer more easily. However, perhaps if I provide
an exact listing of the columns, you can give me a revised "Vlookup" function
that will work.

Sheet #1 has many columns, including these columns:
C = First Name
E = Last Name
T = Birthday (in the format 2/6/2008)

Sheet #2 has fewer columns, including these:
A = First Name
B = Last Name
D = Years old (in the format "20" for someone twenty years old)
E = Phone number

I want to create a new worksheet that will include all the columns in both
worksheets, including these columns, drawing from the rows in the two
different worksheets:

First Name
Last Name
Birthday
Years Old
Phone number

Thanks for any further help you can provide! - Bob Judge

-------------------------------------------------------------------

 

[akphidelt]

Alright, well you need some common value between the two worksheets in order
to correctly join them.

For instance... Last Name

If there is different last names in every cell you can use the last name as
your vlookup.

If there are multiple common last names then create a dummy column where you
combine the first and last names... which would look like =A1&B1... that is
if the last name was in column A and first name in column B

What I'm trying to get at is that it is mandatory that you find some
characteristic between the two sheets that share some common value.

Then do the vlookup to get sheet 2s data.

Let me know if this helps.

 

[Robert Judge]

Dear Akphidelt:

Thanks for staying with me on this. OK, let me provide some more information.

Both sheets have First Name and Last Name columns. Some of the names are
common to both sheets. For instance, John Smith and Mary Jones may be on
both sheets. However, the first sheet may have John Jones, who is not on the
second sheet, and the second sheet may have Mary Adams, who is not on the
first sheet. My previous post provided the exact Column names of each sheet.

Unfortuntely, when you instruct to do the " vlookup to get sheet 2s data," I
get lost. I don't understand the function enough to be able to create it
properly.

With the information above and in my previous email, can you give me the
function exactly and tell me where to put it?

Thanks again for any further help you can provide. - Robert Judge
------------------------------------------------------------