| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup across multiple columns within multiple sheets | Excel Discussion (Misc queries) | |||
| Multiple lookup values and adding multiple rates across together | Excel Worksheet Functions | |||
| Lookup using multiple sheets and multiple criteria, sorry if 2 pos | Excel Worksheet Functions | |||
| Lookup using multiple sheets and multiple criteria | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
![Melvin Purvis[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
