Excel help

Hi all,   I have list of LGA location names in excel file. An example are as follows:     Currently after I extract the data, I use look up function to get the New LGA column to replace the ...