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.

"Jayne" wrote:

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

Sheet 2:
Number + address
9876 12 Commercial road

Desired out come sheet3:
Number + email address + address
9876 12 commercial road