possbily using VLOOKUP
check out help and post back with more details - workbook / worksheet names,
ranges, how the data is arranged on the sheets etc - if you require further
assistance (but please don't attach a workbook)

Cheers
JulieD

"Brown" wrote in message
...
I want to take to sets of ID numbers with different associated data and
combine them on one sheet.

How do I do this?