bambi555
04-27-2016, 06:18 AM
Hi all,
Im trying to combine data from two separate data sets, one of which only has a subset of values from the other. Its a bit hard for me to explain so Ive attached an example. In sheet5 and sheet6 are the two data sets I have and in sheet7 is want I want to end up with. All the names with the same IDs in column B of sheet 6 should end up with the same ID from column B of sheet5.
Sorry if this is difficult to understand. Im sure there is some simple way to do this but I cant figure it out.
Thanks in advance for any help you can provide.
Im trying to combine data from two separate data sets, one of which only has a subset of values from the other. Its a bit hard for me to explain so Ive attached an example. In sheet5 and sheet6 are the two data sets I have and in sheet7 is want I want to end up with. All the names with the same IDs in column B of sheet 6 should end up with the same ID from column B of sheet5.
Sorry if this is difficult to understand. Im sure there is some simple way to do this but I cant figure it out.
Thanks in advance for any help you can provide.