Combining Excel sheets

[Torturednacho]

I'm looking to get information from 1 Excel sheet based on an ID and have it match up to the ID in question.

e.i . I've got 1 excel sheet that lists client IDs .. and another the lists the client contact information (company, phone, email) ..

So I need to combine these making sure the right information is with the right ID.

anyway?

 

[SkipVought]

Hi,

What data is common to BOTH?

A coordinated sample of data from both sheets would be helpful.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]