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

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

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

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

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