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