joining info from two lists

[Hutia]

Dear All,

I am not sure it this can be done. I have some info one one tab from two spreadsheets; in one lists (columns A:G) there is some information, but no NHS number, in the other list (column H:I) there is the NHS number and some info. Is there a way to combine the information so that either columns A:G have the correct NHS number assigned to them, or all the info from columns A:G is added to the corresponding date of birth form columns H:I? My spreadsheet does not have headings (I only put them for your information)

Column A Coumn B column C column D Column E Column F Column G Column H column I

name date of birth address notes notes notes notes date of birth NHS number

It is probably too ambitious but I though I'd try to see if this could be done.

Many thanks for looking into this post.

Regards,
hutia

 

[steve the fish]

Maybe but what you provided is too vague. You are looking for something in both lists that can identify themselves as the same. If you dont have that then you cant. You have only said there is a number and some info in one of the lists..

 

[hiker95]

Hutia,

It is always easier to help and test possible solutions if we could work with your actual file.

Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells and worksheets.

If the workbook contains confidential information, you could replace it with generic data.

 

[Hutia]

Hello, thank you for the advice, so I have uploaded the file.

https://app.box.com/s/4zr102vpno60ia30lyxas3q3g5voyo3z

Basically the date of births in columns B and H are more or less the same, but the nhs only corresponds to the dob in column H.

Regards,
hutia

 

[Fluff]

If you have 2 people with the same dob, how do you tell which is the correct NHS number?

 

[Hutia]

The NHS number only corresponds to dates of birth in column H, so if there was a case that H1=H2 they would have to have different NHS numbers, unless there was a duplicated entry.

I can see there might be a problem with column B as B1 might be the same as H1, and then B1 would have to have one of two different NHS numbers. Could we concatenate some of the info? I have tried but it did not work for me.

 

[steve the fish]

I think you misunderstand. DOB is not an appropriate way to uniquely identify people. Lots of people share birthdays. Indeed in your list there are dates that are the same with different NHS numbers.

 

[Hutia]

Yes, I can see it now. Thank you all for your replies, and sorry to have wasted your time.

Regards,
hutia