- Image and text skills
In life and work, we often encounter the need to quote the data in Table 1 to Table 2.
How to quickly find other table data?
Let me teach you a little trick on how to use WPS to find other table data in one second.
■First open the form and position the cursor at B2 of Form 2.
Click Insert Function - Common Formulas - Find other table data.
We select Table 1 A1:C11 in the "List to be cited".
Enter Table 2 A2 in "Query Conditions", and enter Table 2 Column B in "Which column content to return".
Click OK to quickly search for other table data.
Have you learned this black technology?
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/WPS-kuai-jie-cha-zhao-qi-ta-biao-ge-shu-ju.html
评论列表(196条)
测试