Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to merge historical and current data using a common id fiel
I need helping merging historical data with current data. The data in the
two workbooks is similar but not identical but both have a common id field. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to merge historical and current data using a common id fiel
Look in excel help at the vlookup function or the lookup function.
-- Regards, Tom Ogilvy "leedelee" wrote in message ... I need helping merging historical data with current data. The data in the two workbooks is similar but not identical but both have a common id field. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to merge historical and current data using a common id fiel
Hi,
Maybe you can post the format of both workbooks? When you say two workbooks, is this just two worksheets is there only two worksheets involved? Maybe the headers would be enough to work with from the worksheets? Thanks, "leedelee" wrote: I need helping merging historical data with current data. The data in the two workbooks is similar but not identical but both have a common id field. Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to merge historical and current data using a common id
The historical data contains multiple rows I need to merge which doesn't seem
to work well with Vlookup. When I try it I only get data from the first occurance. Thanks leedelee "Tom Ogilvy" wrote: Look in excel help at the vlookup function or the lookup function. -- Regards, Tom Ogilvy "leedelee" wrote in message ... I need helping merging historical data with current data. The data in the two workbooks is similar but not identical but both have a common id field. Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to merge historical and current data using a common id
Question... Do you have instances where one ID will exist many times in both
the historical data and in the current data? That is can ID# 1234 exist more than once in the historical sheet and more than once in the current sheet? If not then you can use Vlookup. You are just doing it in the wrong direction. Where you have multiple instances of the ID you want to look up the unique instances of the ID in the other sheet... If it is a many to many relationship then this gets really ugly... HTH "leedelee" wrote: The historical data contains multiple rows I need to merge which doesn't seem to work well with Vlookup. When I try it I only get data from the first occurance. Thanks leedelee "Tom Ogilvy" wrote: Look in excel help at the vlookup function or the lookup function. -- Regards, Tom Ogilvy "leedelee" wrote in message ... I need helping merging historical data with current data. The data in the two workbooks is similar but not identical but both have a common id field. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 07, how do I merge two sprdshts with a common column? | Excel Worksheet Functions | |||
how can I check the current owner of the file stored in a common D | Excel Discussion (Misc queries) | |||
How do I merge 2 excel spreadsheets containing some common info? | Excel Worksheet Functions | |||
Excel: how to merge data from 2 workbooks with 1 col. in common? | Excel Discussion (Misc queries) | |||
Auto Importing of text fiel data | Excel Programming |