查看原文
其他

Searching across Multiple worksheets | Sinokap IT Tech Sharing

www.sinokap.com Sinokap 2019-11-08

Sinokap China IT Service KDB



Searching Data from Multiple worksheets


To pull information from one worksheet, you may go into the sheet and extract the values you want. This process will be difficult and time-consuming when you have multiple worksheets. 


Here are two methods to achieve this.


https://v.qq.com/txp/iframe/player.html?width=500&height=375&auto=0&vid=s0901rmih35

The video is reproduced from the network.

If any infringement, please contact us.



Vlookup Function▼


Vlookup stands for Vertical Lookup. It is a function to look up and retrieve data from a specific column in a table. 




INDEX-Match Function▼


Unlike Vlookup function, Index-Match function allows you to lookup values in a table based off of other rows and columns at the same time. 



PAST REVIEW





Create a Searchable Dropdown List

Introduction to Ishikawa Diagram

Combine Excel Files into One

How to Create a Team Site

What is SharePoint







Sinokap offers a full range of IT services to clients in different industry, scale and business nature, including IT on-site service delivery, IT outsourcing services, IT infrastructure services, IT consulting services for end user computing, Server Maintenance, Microsoft service, Linux service, Cisco Network Maintenance and etc. Please feel free to contact us if you have any IT problem.



Please feel free to contact us for any China IT Support requirements. Sinokap Shanghai will provide Professional IT service for you.


如您有任何中国IT服务支持需求,请随时联系我们。Sinokap上海鸿泷信息致力于为您提供专业高效的IT服务。


Contact Us

E-mail:       service@sinokap.comHotline:       400-608-5168Website:      www.sinokap.com


Sinokap ∣ We Make IT Simple!长按,识别二维码,加关注



    您可能也对以下帖子感兴趣

    文章有问题?点此查看未经处理的缓存