Merging two sets of data

**hongkongrubbish** · 10-07-2011, 01:07 AM

Dear all,

I have a problem that has been frustrating me for a long time.
I have a series of data as follow:

Name | Age | ***
John | 13 | M
Mary | 18 | F
Peter | 10 |M

Then I have another set of data as follow:

Name | Height | BMI
Peter | 120cm | 25
John | 125cm | 30
Mary | 150cm | 25

If I want to merge them, say

Name | Age | *** | Height | BMI
John | 13 | M | 125cm | 30
Mary | 18 | F | 150cm | 25
Peter | 10 |M | 120cm |25

What should I do in order to merge them in the quickest way?
Thanks everyone !!

**Azam Ali** · 10-07-2011, 01:12 AM

see attatchment

is it help?

**inayat** · 10-07-2011, 01:12 AM

You can use vlookup provided that all the names are different. Attached sheet may help...

**hongkongrubbish** · 10-07-2011, 03:34 AM

COOOL!! They all worked!! THanks every one !!! ; )

**Azam Ali** · 10-07-2011, 03:40 AM

If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.