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