1. Make an address code table. This address code is specified and will not be changed. As shown in the figure, we will organize it as follows. Only a part, not all, is listed here.

2. Enter the employee's ID number and fill in the corresponding identity information, as shown.

3. First, use the function to extract the household registration. As shown in the figure, we enter the conditional format of formula =if in the corresponding cell.

4. Enter a complete formula, as shown in the figure: = if (d3 = "error", "error", if (isna (vlookup (left (b3,6), area, 2, FALSE)), "the area corresponding to this address code does not exist", vlookup (left (b3,6), area.

5. After the input is completed, we can press Enter, and the household registration location has been extracted.