Multiple same name lookup?
 

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!

Multiple same name lookup?
 

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


"Melvin Purvis" wrote:
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!