How to automatically enter data corresponding to another table in excel table How to use data from another table in EXCEL

How to automatically enter data corresponding to another table in excel? When we use excel tables, we often need to use data from another table, but it is very troublesome to manually search one by one. So is there any way to reference the data from another table? Next, let this site carefully introduce to users the method of referencing data from another table in Excel. EXCEL method of referencing data from another table 1. Open the table with data, and open the data you want to automatically correspond to the results on another table.

2. Open the corresponding content, as shown in the picture. I want to automatically synchronize the corresponding performance appraisal results through the person's name, and then proceed to the next step after confirming the idea.

3. Find the "Formula" menu above the excel table. After opening it: Find "Insert Function" next. The function reference found in this way is easier to understand.

4. When you open the inserted function, a wizard for using the inserted function will pop up. At this time, you need to click the drop-down triangle button in the wizard dialog box as shown in the figure. The functions to be used will be displayed here. The type of function.

When using the vlookup function in PHP, you may encounter a "Function vlookup not found" error. This error may be due to incorrectly entered function names, version compatibility issues, or other factors. To solve this problem, PHP editor Strawberry recommends that you follow the following steps: Check whether the function name you entered is correct, that is, "vlookup". Make sure that the PHP version you are using is compatible with the vlookup function. Find "Find Referenced Functions" in the drop-down menu that selects the function type, and find the vlookup function here. If the above steps don't resolve the issue, continue reading this article for more detailed troubleshooting guide.

fenye6. Next, the first parameter of the insertion function is the value that needs to be searched in the first column of the data table, which is the referenced data. 7. Enter the area containing the reference data and result data, place the mouse cursor in the second column, and enter the area where the data is located.

8. The third parameter determines which column of the area the answer to be found is in, thereby determining the location of the referenced data.

9. The last parameter determines the matching method of the data, whether it is exact matching or fuzzy matching. To find the performance salary of the specified person, exact matching should be used.

10. Click OK. You will see the corresponding answer after the name. Use the filling pie to drag down until the column is full. At this time, you can directly enter the name in column A automatically. Corresponding data! ! ! ! Finally, save the form and open it later to directly enter the person's name to find the answer.

The above is the detailed content of How to automatically enter data corresponding to another table in excel table How to use data from another table in EXCEL. For more information, please follow other related articles on the PHP Chinese website!