Excel - Top 6 search functions

In the first place in the search functions for matching data from two tables, is the SVYHLEDAT or VLOOKUP function, if we have English Excel. We will show you how the function can match data exactly, but also about the approximate match in case we need to match numbers into intervals.

Next, we will guide you through the INDEX, SEARCH, SEARCH and INDIRECT LINK functions.
A new search feature is XLOOKUP, which revolutionizes data retrieval and pairing. The function is available only to users with a Microsoft Office 365 license. All search functions should be handled by the IFERROR function in case the function returns an error condition.

Basic knowledge of PC and Excel.

To all Excel users.

Search function

• SEARCH - VLOOKUP
• SEARCH - HLOOKUP
• INDEX
• LOOK UP - MATCH
• INDIRECT
• XLOOKUP

Logic function

• IFERROR

Know the TOP 6 search functions in Excel and be able to use them.