About the method of matching the same content of two columns in Excel

Correct your problem: excel is the name of the program, the file with excel is called a workbook, its name is as follows: , each workbook file has multiple worksheets, such as sheet1, sheet2, ......In this way, the ** we see in the excel file is actually a worksheet in a certain workbook file, usually sheet1 like this.

Let's talk about your problem, in fact, your problem is very simple, and it can be solved with the vlookup function. The usage is not too complicated, for example, in your Table 1, column A is the code, column B is the name, and you want to display the quantities in Table 2 in column C. Let's say you have these two ** in two different files, and you need to enter the formula C1 in the first table:

vlookup(a1,'[book1,xls]sheet1'!a:b,2,0)

When the cursor points to a small dot in the lower right corner of cell C1 and the cursor changes to a small black cross, double-click the left button or press the left button to drag down. You get the results you want.

Use the vlookup function, this function has 4 parameters, the formula: =vlookup(a,b,c,d).

a: is your inventory code (that is, the query condition, use a to call up the content of the same row corresponding to a) b: search range (refers to the range of the content you want to match) c: the cell display content (this part is a number; e.g. 3 refers to the third column in the b range).

d: Find property (0 or 1 can be filled, 0 means exact search, 1 means fuzzy search) Your question can be expressed as: =vlookup(A2,[book1]sheet1!a:b,2,0)

Let's say column A matches the same content of column B. (In the first row of the header, column A has more values than column B).

Enter the formula =VLOOKUP(B2,$a:$a,1) in cell C2 to quickly fill column C; (C is the same for those with values; for the inconsistency of n a) select columns, filter, c columns in ascending order;

First of all, the explanation on the 1st floor is correct, but I personally think that the function formula needs to be modified a little, enter in C1 of the sheet1 table:

vlookup(a1,sheet2!a:b,2,false)

Preparation Tools Materials: A computer with Windows 10, Microsoft Office Home and Student Edition 2016 Excel software.

1. First of all, enter two sets of data in an excel sheet. You need to compare the same data and enter the results into column C.

2. Enter the formula in cell C1: =if(countif($b 1:$b 10,a1),a1,")

3. Click Enter to see if there is no matching option, it will be empty.

4. Click the drop-down formula to get the corresponding calculation result, and the corresponding same data will be extracted and displayed in column C.

Vlookup is available.

1. Open Excel** on the computer.

2. After opening Excel**, enter the formula =vlookup(B3,A3:A6,1,0).

3. After entering the formula to confirm, if there is no same, an error will be displayed.

4. Pull down and copy, if there is the same, the name will be displayed.

Vlookup is available.

1. Open Excel** on the computer.

2. After opening Excel**, enter the formula =vlookup(B3,A3:A6,1,0).

3. After entering the formula to confirm, if there is no same, an error will be displayed.

4. Pull down and copy, if there is the same, the name will be displayed.

Here's how two excels match the same data:

Tool Raw Materials: Xiaomi Bi Qianbi Windows10, WPS2019 Steps: 1. Open [Two **], select [File Cell], select [Formula], and select [VLOOKUP Function].

2. Set the search value to [Compare Data], set the data table to [**Data], and the shortcut key [Shift+F4] for absolute reference.

3. Set the number of result columns, write [false] to the matching condition, and click [OK].

4. Double-click [Cell] to quickly fill it.

Here's how:Materials Required: Excel 2007 Presentation.

1. As shown in the figure below, the first table in the workbook is a transcript.

2. In the second table, fill in the correct score after comparing the names of the people. Click on cell B2 and click on "FX".

3. Find the "vlookup" function and click "OK".

4. Set the first parameter to "A2", select the two columns of name and score in Table 1 for the second parameter, select the second column of the third parameter "2" (return the second column of the second comparison parameter), enter "false" for the last parameter, and click "OK".

5. At this time, you can compare and fill in the normal score, and finally pull down to fill.

6. After dropping down and filling, you can compare the data in the two tables and fill in the correct score value.

Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation capabilities, and charting tools, combined with successful marketing, make Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.

1. Open two excel documents, click on the blank box in document 1, enter [=vlookup], and click to select the formula; 2. Select the data required by the formula, first select the cells in the first column that need to match the data, select only one, and then enter the comma [,] in the English state3. Return to the second excel document and select all the data in **; 4. Back to Document 1. Suppose we want to match the class information in the fourth column of document 2, so enter [4,0] in the formula (the comma is also in English) (ps: the prompt message asks us to choose [true] or [false], no need to choose, just press the enter key); 5. The effect of the final formula is as follows: [=vlookup(b2,sheet2!

a1:b8,4,0）】。After completing the above settings, click the enter key to complete the data matching.

When using Excel, you can paste one of the ** directly and copy the other**, in this case the content of the two ** is the same.

If two Excel tables match the same content, you can put the two tables in one ** for searching.

How do two ** match the same content quite strongly? Because everything is done, there is no development prospect, which is a very good bottleneck.

How to match the corresponding data of 2 **, the solution is as follows.

1. First, select the cells that need to match the data, and enter the function: =vlookup(.

2. Then select the desired search object with the mouse.

3. Then select the desired search content.

4. The number of matching data in the second column, enter the number of search columns: 2.

5. Then enter Exact Lookup: 0. Click the Tick icon.

6. At this time, you can see that matching two ** identical data allows them to complete the corresponding operation.

excel matches multiple columns of data with formulas:

VlookUp is a very heavy data matching tool in Excel, and if you are proficient in using this function, you can greatly reduce your workload.

1. Open the two tables separately and select the ** you want to match the data.

2. Select in the cell of the personnel information table, and be sure to select the table with complete data for comparison among the 2 tables, enter "=vlookup", and the system will automatically pop up a dialog box.

3. The function system at the bottom of the dialog box will prompt, =vlookup (the value to be found, the area to be found, the column to be returned, the approximate or exact match), note that the symbol must be entered in the English state.

4. Enter =vlookup(a3,e:f,1,0), and then press enter, it will return the value "name" you are looking for, if you enter =vlookup(a3,e:f,2,0), it will return the time.

5. After the first cell returns time, we can pull down and copy when the mouse pointer changes to a solid cross, and there is no normal name appearing, and the return value is "n a".

Fourth, Wang Wu, is absent from training.

There is no need to change the personnel situation and formula, each time you copy and paste, a new training sign-in sheet, you can quickly query the absent personnel.