Match and replace with index

Hi Leith,

Thank you very much for reply.
I have attached two files:
Original file : Suburb_City_State_Example_Final.xlsx
Expected File: Suburb_City_State_Example_Final_Result.xlsx

No...I am not using this index number as a formula in the sheet.

In the attached fie, there are three sheets:
Suburb_City_State, City and State.

This is just the sample file. We got 200000 rows. We will prepare the CSV file which we can upload in the MySQL database.
In the sheet1 i.e. "Suburb_City_State", we got the list of Suburb with corresponding City and State in front of that Suburb.

Now first we want to replace City in sheet1 with the index number of that City in Sheet2 i.e. 'City'.
Then second we want to replace State in sheet1 with the index number of that State in Sheet3 i.e. 'State'.

Finally I will make one CSV file. Which will have only Sheet1 with Suburb Name with corresponding index number of city and state. This is to upload in MySQL database.

To answer your question regarding the index. In the sheet2 i.e. 'City', we have already placed the City in the sequence so that we can take its index(or number of row) to replace in sheet1.

Please let me know if you need more information. Thanks again.