Hi,

We got three sheets in a excel file.
Sheet1: Got three columns. Street, City Name and State Name.
Sheet2: Got one column. City
Sheet3: Got one column. State

Now in Sheet1, I need to replace the City Name with the index number of that City in Sheet2. And the same way, in Sheet1, I need to replace the State Name with the index number of that State in Sheet3.

Please let me know, how can I do this in VBA?
Thank you very much in advance.