"The twists and turns" Excel technique hundred example 04. Two Table Left connection

First look at the following two tables:

Form one:

Table Two:

Two tables are numbered, how do you turn two tables into a table according to the numbers?

The first step:

Ctrl+h, replace the space.

Step Two:

Put two of the tables in the same sheet:

Step Three:

Write the score on the third column, and then use the formula

Formula: =vlookup (A2, $E $: $F $7,2,0)

So we can see the following effect:

The #n/a can be replaced by 0 or "unknown".

Note: If you delete E and F now, you will find that the score is gone again, you can add the new score column, copy Paste as the value will not disappear.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

"The twists and turns" Excel technique hundred example 04. Two Table Left connection