VLOOKUP function, in the find and reference, the two tables must have the same a data (format must also be the same) to connect, this data is assumed to be the name of it, the first choice of the name of your B table, the second choice of the A table to find the range of data, but you want the data must be in the name of the back, not in front of the third choice of the B table you want the data from the name The third choice is the data you want in the B table in the first few columns from the name, and the last choice is 0.