Hi,

I was wondering if there was somebody who could help me with what I hope is
a quick problem.

Basically, I have two worksheets.
In one worksheet, I have a column full of unique id numbers. And related to
that specific id number, I have rows of information with info like street
address and name.

In another worksheet, I also have a column full of unique id numbers. Some
of these id numbers match up with the id numbers that are in the 1st
worksheet. But there's many extraneous records that are irrelevant. In this
worksheet, I have rows of information with info on City and State.

So basically, I was wondering, is there any way I can match up the records
with id numbers that match up on worksheet 1 & 2 and discard the records on
worksheet 2 that don't have a corresponding record in worksheet 1? aka, I'd
like to match up the street address, name, city and state for onto one
worksheet. There's just too many records for me to do this by hand.

I'm sorry if this was confusing, I'd be more than happy to explain further.
Any and all help would be GREATLY appreciated. Thanks!

Brian