Combining data

J

Jayne

If i have data in 2 worksheets with a unique number at the start can i
combine the data from both in one sheet:

Sheet 1:
Number + email address
9876 [email protected]

Sheet 2:
Number + address
9876 12 Commercial road

Desired out come sheet3:
Number + email address + address
9876 [email protected] 12 commercial road
 
T

tim m

You could us VLOOKUP for this.

In sheet three in the cell to the right of your number try this:

=VLOOKUP(A1,Sheet1!A1:B1,2,FALSE)

and in the cell to the right of that one:

=VLOOKUP(A1,Sheet2!A1:B1,2,FALSE)

The first formula looks at A1 in sheet 3 which is your number, it then goes
to Sheet 1 and looks at the data you have hi-lited (the numbers and names) to
find your number. It then looks at the 2nd column of that data (which is the
email in your sample date. The FALSE tells it to look for an exact number
match.

The 2nd forumla does the same thing excpet it is looking for the address in
sheet 2.
 
B

Bernard Liengme

In the numbers are in the same order in both worksheets: use formulas such
as =Sheet1!A1 and =Sheet2!C1 in Sheet3 to extract data from Sheet1 and
Sheet2. Or use Copy and Paste

If the ID's are not in the same order have a peek in Help at VLOOKUP and
come back if you need help with that function.

best wishes
 
Top