Combine,match and align 2 excel sheets.

[Closed]
Report
Posts
1
Registration date
Thursday May 8, 2014
Status
Member
Last seen
May 8, 2014
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
I want to combine two excel sheets. First excel sheet has patient ID (below 18 years) and their gender, age and race.Second one has patient ID (above and below 18 yrs old) and their lab result. I want to combine and align the Patient ID, age, gender, race and labs to keep only below 18 yrs of age.

1 reply

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
Anvit, Good evening.

Probably you can do this using a VLOOKUP function for a dinamic values or you can use a VBA CODE for a permanent values.

Please, save your files at a free site, www.speedyshare.com, and put a link to download here.

It's easy and possible to help when we can see the layout of your data.