Sounds like you need to use VLOOKUP, then paste the
CityID over the CityName. To learn how to use it, see:

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

-----Original Message-----
Hi Could anyone help me with this one: -

I have an Excel workbook with two worksheets: sheet1 and
sheet2.

On sheet1, I have 2 columns of data:-
Column 1 - CityID
Column2 - CityName

On sheet2, I have a list of 500 office locations, some
of which are in the
same city. Sheet2 has several columns, one of which is
the city location of
the office.

I am trying to prepare the Excel sheet ready to import
into Access and want
to replace each instance of the city location listed on
sheet2 with the
CityID number from sheet1 where the city is matched. For
example: -

Sheet 1
CityID CityName
1 Aberdeen

Sheet2
In the city column, replace all instances of Aberdeen
with a 1

Can anyone point me in the right direction of how to go
about this?

Thanks for all and any help!

Kindest Regards

Lee
.