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