Use the VLOOKUP function formula, you can quickly query and extract the corresponding value.

Specific steps:

Locate to the second column of Table 2 (for example, cell E3)

Use the formula = VLOOPUP (D3,A:B,2,FALSE)

The formula will be pulled down (the mouse is placed in the lower-right corner of the cell, there is a black bolded cross symbols, dragged down the auto-fill)

If you do not want the formula, but just the results, you can quickly query and extract the corresponding value. want the formula, but just the result, you can use the selective paste method to remove the formula.

Specific method:

Select the cell area containing the formula, and copy.

Right-click the cell in the original

Click "Selective Paste"

Choose "value and number formatting" can be.