VLOOKUP Function Archives

VLOOKUP Function

Excel VLOOKUP to Return Multiple Values in One Cell Separated by Comma

Oct 1, 2022 Excel Formulas

This article illustrates how to Vlookup and return multiple values in one cell in excel separated by a comma. Excel has several functions for Vlookup ...

How to Vlookup and Return Multiple Values in Drop Down List

Sep 27, 2022 Excel Formulas

VLOOKUP is a useful function to look for the values in the dataset and return the necessary part of that dataset. If you are curious to know how you ...

How to Convert INR to USD in Excel (4 Methods)

Oct 2, 2022 Excel Formulas

Conversion of currency is very common now. People visit from one country to another, they need to convert their currency. In case of buying any ...

Excel VLOOKUP Function to Return Min Value from Multiple Hits

Sep 25, 2022 Excel Formulas

Looking for ways to know how to VLookup to return min value from multiple hits? We can VLookup to return the min value in Excel using different ...

Excel VLOOKUP for Partial Match in Table Array (3 Examples)

Sep 22, 2022 Excel Formulas

If you are searching for some tutorial about how to use VLOOKUP for a partial match in any table array of Excel then you have landed in the right ...

Excel VLOOKUP with Multiple Criteria in Horizontal & Vertical Way

Sep 21, 2022 Excel Formulas

Excel is extremely powerful for large data handling and calculations. Sometimes, we need to look up some values horizontally and vertically according ...

How to Create a Monthly Calendar in Excel (3 Effective Ways)

Sep 19, 2022 Advanced Excel

Excel is a great tool to automate several calculations and templates. You can create many types of monthly calendars through Excel. If you are ...

Return Value If Time Is Greater Than and Less Than a Range in Excel

Sep 7, 2022 Excel Formulas

Sometimes, we need to find remarks if time is greater than and less than in Excel. In that case, there are starting and closing times. We need to ...

Vlookup with Time Range in Excel (5 Easy Ways)

Sep 7, 2022 Excel Formulas

Sometimes, we need to VLOOKUP in a time range to get the value according to our desire. In the article, we will demonstrate to you five quick methods ...

How to Merge Two Tables in Excel with Common Column (5 Ways)

Sep 25, 2022 Excel Formulas

Looking for ways to know how to merge two tables in Excel with a common column? Sometimes, we want to merge two tables that have a common column. ...

Excel If Time Is Between Range Then Return Value

Aug 31, 2022 Excel Formulas

Microsoft Excel offers ways to work with dates and times as data points. While analyzing data, we often need to distinguish data points from the rest ...

How to Merge Two Tables in Excel (5 Methods)

Sep 25, 2022 Excel Formulas

In the workspace, we frequently encounter the need of merging two separate tables with each other. Merging two separate tables will increase the ...

How to Merge Two Excel Sheets Based on One Column (3 Ways)

Aug 28, 2022 Excel Formulas

In small businesses or corporate organizations, we use MS Excel to collect data. Information about the same people or entity is stored in different ...

Using VLOOKUP to Merge Two Sheets in Excel (with Easy Steps)

Aug 25, 2022 Excel Formulas

If you are looking for VLOOKUP to merge two Excel sheets, you have come to the right place. In many cases, we have data in two different Excel sheets ...

How to Filter Missing Data in Excel (4 Easy Methods)

Sep 1, 2022 Excel Formulas

Filtering for a value in a list, whether missing or not, is too common in Excel. But the excel filter command can't do it, we need to use formulas ...