LOOKUP Function Archives

Excel Formula to Change Zip Code to State (5 Examples)

Mar 28, 2023

In Excel, you may need to do a lot of work while working on a worksheet. One of the important works that can be done by Excel is to change a zip code ...

Excel Formula to Change Zip Code to State (5 Examples)

How to Lookup ZIP Code in Excel (4 Suitable Methods)

Nov 20, 2022

If you are searching for how to look up a ZIP code for the name of a country or city in Excel, then you have come to the right place. Today, in this ...

How to Lookup ZIP Code in Excel (4 Suitable Methods)

Solved: Excel Formulas Not Working in Google Sheets

Dec 28, 2022

The article will show you some solutions to the problem of Excel formulas not working in Google Sheets. Although Google Sheets and Microsoft Excel ...

Solved: Excel Formulas Not Working in Google Sheets

How to Create a Lookup Table in Excel (5 Easy Ways)

Dec 28, 2022

When we have a vast dataset in Excel, it’s a bit hard to look at and find specific data from the dataset. But Excel is too awesome, it has many ...

How to Create a Lookup Table in Excel (5 Easy Ways)

How to Fill Empty Cells with Last Value in Excel (4 Handy Ways)

Jan 15, 2023

Microsoft Excel provides extraordinary features and formulas to fill empty cells with the last value. While dealing with a massive dataset, you may ...

How to Fill Empty Cells with Last Value in Excel (4 Handy Ways)

How to Go to Last Non Empty Cell in Column in Excel

Dec 12, 2022

Users often need to find the last non-empty cell of a column. In a long dataset, it is quite time-consuming to find the last non-empty cell or the ...

How to Go to Last Non Empty Cell in Column in Excel

Excel If Date Is Between Range Then Return Value

Jan 8, 2023

In this post, we examined 2 simple ways to find value in between date range in Excel and return it. We have shown them with proper guidance and clear ...

Excel If Date Is Between Range Then Return Value

Vlookup with Time Range in Excel (5 Easy Ways)

Apr 11, 2023

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 ...

Vlookup with Time Range in Excel (5 Easy Ways)

How to Return Value If Date Is Within a Range in Excel

Feb 8, 2023

This tutorial will demonstrate how to return the value if the date is within range in excel. When delivering products or submitting important ...

How to Return Value If Date Is Within a Range in Excel

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

Oct 23, 2022

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 ...

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

How to Reverse Score in Excel (4 Easy Ways)

Dec 8, 2022

For better analysis in many surveys and questionnaires, a reverse score is used. Generally, in the reverse score, we transform 1 = 5, 2 = 4 and so ...

How to Reverse Score in Excel (4 Easy Ways)

Excel Formula to Lookup Value in Table (3 Suitable Examples)

Feb 9, 2023

When working with an enormous dataset, it is a very frequent need for us to find some value in the table of the dataset. Finding it manually and ...

Excel Formula to Lookup Value in Table (3 Suitable Examples)

How to Calculate Letter Grades in Excel (6 Simple Ways)

Feb 8, 2023

The result in our transcripts is represented by the letter grades at the end of any exam. But it becomes difficult for the teachers to calculate ...

How to Calculate Letter Grades in Excel (6 Simple Ways)

How to Create Table of Contents Without VBA in Excel

Dec 7, 2022

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to create a table of contents with ...

How to Create Table of Contents Without VBA in Excel

How to Calculate Weight Gain or Loss in Excel (5 Easy Methods)

Mar 5, 2023

This tutorial will demonstrate different methods to calculate weight gain or loss in Excel. In the modern era, whether you are adjusting your own ...