Excel Series - Quick Search in Excel | Sinokap IT Tech Sharing

Sinokap China IT Service KDB

Searching in Excel is not difficult most of the time. You can use "Ctrl + F" to do a quick search. However, if you're working with a really big worksheet, try one of the Methods below that can save you a lot of time. They're easy to start with.

1

Create Google-like Excel Search

A Searchable Dropdown List helps you to locate a certain item in the list when you have an extremely long list of data.

2

Search Across Multiple Worksheets

With the help of VLOOKUP function and INDEX-MATCH function, it is easy to pull information from multiple worksheets into one sheet.

﹏﹏﹏﹏

Sinokap IT always supports you with Professional IT Services in Shanghai, China.

Sinokap IT团队为您在中国提供专业的技术支持~

﹏﹏﹏﹏

3

DGET Function- Alternative to VLOOKUP

As an alternative to VLOOKUP, DGET Function is simple to use as a tool to extract a single value from a column of a database that matches the criteria.

4

The Latest XLOOKUP Function

The New XLOOKUP Function can perform lookups in both Vertical and Horizontal ranges, as the Successor to VLOOKUP and HLOOKUP Function.

End

Past Review

Sinokap公众号每日放送IT小技巧，让你的工作、学习、甚至是日常生活更加高效、便捷。

Sinokap China IT Service Team daily broadcasts Professional IT Support Tips and Tricks. We are engaged to bring you a variety of IT skills that can be widely used in your business work, study and daily life.

关注我们

Follow us

如果你想了解更多IT资讯和小诀窍~

If you would like to learn more IT related news and IT Trick Tips.

加入我们

Join us

如果你想变得更强，成为一名专业的工程师~

If you want to improve self-ability and grow into a skillful engineer.

联系我们

Contact us 

如果你需要专业的IT服务支持需求~

If you need Professional IT Support and IT Services in Shanghai, China.

E-mail:       [e-mail]:       [phone]Website:      www.sinokap.comSinokap ∣ We Make IT Simple!长按，识别二维码，加关注