In Lookup table, a new column (City) has been added. VLOOKUP() function does not work anymore (F and G columns returns wrong values). For H and I, HLOOKUP() is used inside of VLOOKUP() to make it more flexible. Now it works.

In Column J, Region is returned using INDEX() function while MATCH() function is used inside it.

District and Region columns are filled using VLOOKUP by looking in Lookup Table which is based on the Store column.