HOW TO MATCH DATA IN AN EXCEL SHEET AND UPDATE IT AUTOMATICALLY

According to the information and arrangement you provided above, enter ==vlookup(b:b, table 2!) in the cells in column d of table 1 in the worksheetb:c,2,0)

I guess not.

Otherwise, what else do you need to do with the database.

1. Open an excel**, take the class data as an example:

2. Open Table 2 of the original data, where some data are simulated.

3. Go back to Table 1 and select the key to hold the middle class cell

4. Input=vl will automatically match the formula, double-click vlookup, if there is no matching, enter it manually:

5. After selecting the formula, select the A2 cell, and then enter the English comma "," at the end

6. Go back to Table 2 and select all the data

7. Because the data in Table 2 is 4 columns, enter a 4 and an English comma, and enter a few columns.

8. If you press the formula enter, you can see that the b2 cell in Table 1 automatically matches the data in Table 2

9. Place the cursor in the lower right corner of cell B2, and after the cursor changes to a cross sliding number, double-click on Zuojian:

10. Effect display:

Assuming that Table 1 is a journal, you need to automatically fill in the summary data according to the name in Table 2.

1. Enter the formula in cell C2 of Table 2: =sumif (Table 1!). $c: $c, $b 2, Table 1! d:d) carriage return;

See Figure 12, select the C2 cell, click right click to copy;

See Figure 23, select the ** column d and e that need to be automatically filled in the summary data, click the right click and click: paste and select the fx icon below;

See Figure 34, actual results: see Figure 4.

Table 1 is sheet1, table 2 is sheet2, for the convenience of calculation, insert a column, then table 1 has 6 columns, respectively a is id, b is time, c is name, d is condition, e is quantity, f is **, table 2 has 4 columns, a is time, b is name, c is quantity, d is **.

For example, if you want to use 100 rows, enter the function in column d in Table 1, and enter =concatenate(month(b2),c2) in d2

Columns A and B in Table 2 need to be entered manually.

Column C input function, C2 input = sumif(sheet1!d$2:d$100,concatenate(month(a2),b2)

sheet1!e$2:e$100)

Column d input function, d2 input = sumif(sheet1!d$2:d$100,concatenate(month(a2),b2)

sheet1!f$2:f$100)

The above solution should solve the problem.

Suppose that the name of Table 1 is sheet1, and the id, time, name, quantity, and ** columns A, B, C, D, and E are respectively. Because I don't know the format of the cells in your table 1, I add a column f, the content is the month, such as January 3, the f column corresponds to the month of January, which is the same as the time format in table 2.

Table 2 is named sheet2, and the time, name, quantity, and ** are columns a, b, c, and d, respectively.

Enter =SumProduct((Sheet1!) in C2 in Table 2$f$1:$f$100=$a2)*(sheet1!

c$1:$c$100=$b2),sheet1!d$1:

d$100)

In Table 2, enter =sumproduct((sheet1!.)$f$1:$f$100=$a2)*(sheet1!

c$1:$c$100=$b2),sheet1!e$1:

e$100)

You can get the data you want, including $b$100, $c$1:$c$100, etc., and the 100 in it can be changed to your number of rows if you are in Table 1. If you want to be in C3, C4, C5....

To get the number you want, copy C2 and paste it into any row in column C.

What are the specific data formats and requirements?