Combining data - variable data size

[Jen30386]

I have 2 worksheets, one with about 500 lines and the other with 1600 lines. The first worksheet - the target with 500 lines, I have a firstname/last name combined field in column C. In column D I need to obtain the status of each of these people from my second worksheet.

I've pasted the columns I need into my target sheet as a new worksheet titled source. Column C has the same combined first name/last name column and column D has the status that I need to move to the main sheet.

I have tried to use a lookup function but it appears that since I don't have the same number of lines, it actually does not pull in the correct status for each person. So, I know I'm missing something but can not figure out what.

I'm using this formula:
=LOOKUP('Contacts orders only'!D:D,source!C:C,source!D:D)

I'm not familiar with all the various formulas and have looked in other threads to find a solution but the reply either goes over my head or doesn't seem to quite fit. Any help or advice would be GREATLY appreciated!!

Thank you!

Jennifer

 

[Kentman]

Welcome to the board Jen.

Am I right in thinking that you have 500 names on one sheet (lets call it sheet 1) and 1600 records on the other sheet (call it sheet 2) and you want to get the status from sheet 2 against the names in sheet 1. Or is it the other way round?

 

[Jen30386]

Kent,

Thanks for replying - you are so quick!

Sheet one, called Contacts nicola5 - this one has 476 rows, 26 columns. The firstname/lastname column is column D and the empty field for status is column E

Sheet two, now called source - this has 1675 rows, 4 columns. The firstname/lastname column is C and the status that I need to move over to sheet one is column D.

Hope that makes it a bit more clear, sorry for that and thank you!

Jenn

 

[Kentman]

Jen,

The other question I need to ask is: with the number of status records being greater than the number of individuals, are there multiple status for each individual and if so how do you want to record those against an individual?

It would be good to post an example.