Hi

you can use VLOOKUP to bring the City and State information from Sheet 2 to
Sheet 1

assume on sheet2 your IDs are in column A, City & State in columns B & C -
starting at row 2 and going to row 1000
assume on sheet1 your IDs are in column A and you want City in D and State
in E

on sheet1 the formula in D2 would be
=VLOOKUP(A2,Sheet2!$A$2:$C$1000,2,0)
on sheet1 the formula in E2 would be
=VLOOKUP(A2,Sheet2!$A$2:$C$1000,3,0)

you could then select these two cells and fill down (select both cells and
then move your mouse over the bottom right hand corner of E2 and when you
see a + double click) the rest of the ID numbers on Sheet 1 to bring the
data across. You could then, if you want, select columns D & E of sheet 1
and use copy / edit, paste special - values to change the formula into the
result and then sheet2 could be deleted.

hope this helps
Cheers
JulieD


"junkit132000" wrote in message
...
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