当前位置:网站首页>Excel two tables are matched according to a column of data

Excel two tables are matched according to a column of data

2020-12-06 13:58:20 Zhang Zhixiang

We are operating excel Time of table , Sometimes a excel To another table , Then we need to use VLOOKUP function ,VLOOKUP The function is Excel A vertical search function in ,VLOOKUP Is search by column , Finally, the value corresponding to the query column order required by the column is returned , Let's introduce it step by step VLOOKUP Function usage , I hope it helped you .

1. Open one Excel form ——a.xlsx, Only the students' names are included , Need to be in another Excel form ——b.xlsx Match the class information of the corresponding students .

                                                                          chart 1. a.xlsx

                                                                                    chart 2 b.xlsx

2. Position the cursor in the cell where you want to display the data

3. Enter... In the cell "=vl", Then it will automatically prompt VLOOKUP function , Double click on the blue function section , You can see that the cell shows the complete VLOOKUP function .

4. Select the cells in the first column that you want to match data , Just pick one , Then enter a comma in English ","

5. Then open b.xlsx form , Select all data

6. Because the message we're going to return is b.xlsx Class information in the fourth column of , So I'm going to put... In the formula ",4,"

PS: The message tells us to choose “TRUE” or “FLASE”, No choice , Just go back

7. After pressing enter , Show the matching data , The effect is as follows :

8. Want to put a.xlsx All the data in the first column in the , Just press and hold the bottom right corner of the first matched class information , When the mouse becomes a solid black cross, double-click to .

版权声明
本文为[Zhang Zhixiang]所创,转载请带上原文链接,感谢
https://chowdera.com/2020/12/20201206135540207t.html