I have a problem that I've been trying to solve for awhile now, I just can't
figure it out.

Please see towards the bottom for data layout. I am using 2003.

At the very bottom is the yesterdays file info. I get the data from a csv, and
manually enter the ticket #.

Today, I start with a new csv file, shown by todays info.

All I really want to do is to pull the ticket numbers from yesterday into
todays info automatically. This has really stumped me for some reason. Maybe
I'm trying to make it too difficult. All I can really think to do is a vlookup,
but it won't work because of the multiple same name entries.

Can anybody please offer me a suggestion, a formula, something???

Many thanks in advance!!


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


yesterdays file
Name Date Qty Ticket#
Adam 12/1 45 4567
Adam 12/7 12 6787
Betty 12/5 67
Mike 1/1 34 5678