Excel Functions Archives

How to Use TEXTJOIN Function in Excel (3 Examples)

Sep 23, 2021 Excel Functions

TEXTJOIN is one of the most important and widely used functions in Excel that has been available from Excel 2019. Today I will be showing how you ...

How to Use VALUE Function in Excel (5 Common Examples)

Sep 23, 2021 Excel Functions

Excel provides several text functions to perform your desired text-related tasks easily and swiftly. Today we are going to show you how to use a text ...

How to Reference Worksheet Name in Formula in Excel

Sep 23, 2021 Excel Formulas

We may know how to work with more than one worksheet in Excel. But sometimes while working with more than one worksheet, we have to reference one ...

How to Use IF ISNA Function with VLOOKUP in Excel

Sep 23, 2021 Excel Formulas

One of the most important and widely used functions of Excel is VLOOKUP. But while using VLOOKUP, we may sometimes face errors when the lookup value ...

How to Find Value in Column Using VBA in Excel (4 Ways)

Sep 23, 2021 Excel Functions

In MS Excel we frequently need to search or find values in the dataset. It could be finding data in the rows or the column. Fortunately, Excel ...

XLOOKUP vs INDEX-MATCH in Excel

Sep 23, 2021 Excel Formulas

In the earlier versions of Excel, we used to use the HLOOKUP, the VLOOKUP, and the INDEX-MATCH functions of Excel to look for a specific value in a ...

How to Use CHOOSE Function in Excel (4 Ways)

Sep 23, 2021 Excel Functions

MS Excel’s CHOOSE function returns a value from a list using a given position or index. The values provided to CHOOSE can be hard-coded constants or ...

How to Use VLOOKUP in VBA (4 Ways)

Sep 23, 2021 Excel Formulas

In terms of searching or seeing some specific values or elements, MS Excel provides various functions. VLOOKUP is one of them. It helps us to search ...

VLOOKUP with Multiple Matches in Excel

Sep 23, 2021 Excel Formulas

One of the most amazing and widely used functions of Excel is VLOOKUP. So far we have learned to pull out a single match from a range of cells using ...

VLOOKUP SUM Multiple Rows (4 Ways with Alternative)

Sep 23, 2021 Excel Formulas

In MS-Excel VLOOKUP is the most used important function to search any data from a dataset or table. In terms of calculation, sometimes we may need to ...

VLOOKUP to Search Text in Excel

Sep 23, 2021 Excel Formulas

One of the most amazing and widely used functions of Excel is VLOOKUP. The number of tasks that you can execute using this VLOOKUP function is ...

How to Use INDEX and Match for Partial Match (2 Ways)

Sep 23, 2021 Excel Formulas

In MS Excel, instead of seeking something with full text or keywords, we may have to use partial text or keywords to look up desired data and ...

VLOOKUP Fuzzy Match in Excel

Sep 23, 2021 Excel Formulas

While working with larger data sets, many times we try to filter out similar types of values. One of these types of matching is called Fuzzy Match, ...

How to Use VLOOKUP for Partial Match in Excel (4 Ways)

Sep 23, 2021 Excel Formulas

VLOOKUP function is generally used for searching or finding any elements within a range or table in Excel. We can find any elements with partial ...

How to VLOOKUP Partial Text in Excel (With Alternatives)

Sep 23, 2021 Excel Formulas

In MS Excel, instead of searching for something with full text we may have to use partial text. Where the lookup value will be returned based on the ...