Multiple same name lookup?

[Melvin Purvis]

I posted something similar to this a few weeks back, and was helped
immensely with the sumproduct function.

A new wrinkle has developed, I don't think sumproduct will work any more, if
it will I don't know how to make it work.

What I am doing is downloading a csv file from a mainframe system every day.
I take the imported csv file, and fill in some cells. It becomes yesterdays
file.

Today, I will import another csv file. If there are any duplicate entries in
that file, I want the missing information that I did fill in yesterday to
populate the cells in todays file. This turns out to be far more complicated
than I thought it would.

What todays newly downloaded file looks like:

Name Date Qty Ticket#
Adam 12/1 45
Adam 12/7 12
Mike 1/1 34
Tom 1/12 4
Wally 11/5 56


What yesterdays manually filled in file looks like:

Name Date Qty Ticket#
Adam 12/1 45 4C567A
Adam 12/7 12 67R87G
Betty 12/5 67
Mike 1/1 34 W5Q678


What I want todays populated file to look like when completed:

Name Date Qty Ticket#
Adam 12/1 45 4C567A
Adam 12/7 12 67R87G
Mike 1/1 34 W5Q678
Tom 1/12 4
Wally 11/5 56

Any ideas on how to approach this one?

Many thanks in advance!

 

[Melvin Purvis]

Anybody? Buehler? One of you smart people has to have done something similar to
this before...