VLOOKUP Function

How to Generate Payroll in Excel VBA (with Easy Steps)

Are you an HR professional and know how to make an employee payroll in Excel? Then, look no further, because in the following tutorial we’ll ...

How to Shuffle Numbers in Excel (7 Easy Methods)

Excel can help you shuffle or randomize different formats of data quickly in easy ways. You can shuffle data within one column as well as around ...

How to Convert Abbreviations to Words in Excel (2 Easy Methods)

In this tutorial, I am going to show you 2 simple methods to convert abbreviations to words in Excel. You can quickly use these methods even in large ...

How to Find 2 Letter State Abbreviations in Excel (4 Ways)

Indeed, while working in Excel we may need to obtain the abbreviation of the State names. Though there is no dedicated function to do this, however, ...

How to Create Table from Another Table in Excel (3 Easy Ways)

Sometimes when dealing with Excel tables, we need to create a new table depending on requirements from the existing data. In this article, I'll ...

How to Create Invoice in Excel with Database (with Easy Steps)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make ...

How to Get Exchange Rate by Date in Excel (2 Suitable Methods)

Exchange rate is very crucial to businessmen, especially those who are dealing with foreign currencies. The rate of exchange varies with time. So, it ...

How to Create an Order Form in Excel (with Useful Steps)

If you are looking for how to create an order form in Excel, then you are in the right place. For international or any domestic business we need to ...

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

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

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

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 Create a Printable Form in Excel (2 Easy Ways)

While working with Microsoft Excel, we may need to store data and perform some useful calculations for our daily work or professional work. If ...

How to Auto Populate Zip Codes in Excel (3 Easy Ways)

Managing data can be very easy if we can populate Excel cells automatically. This article will show you how we can auto populate Zip Codes in Excel. ...

How to Convert Zip Code to State with VLOOKUP in Excel

Zip codes are defined as the postal code of certain cities or states of a country. It is used as a part of the address. Every country has its ...

[Fixed!] Excel VLOOKUP Not Returning Correct Value

Excel VLOOKUP function is a very useful function. You can find out your needed data from a big range of data easily by using the VLOOKUP function. ...

How to Lookup County from Zip Code in Excel

Sometimes users need to lookup a county based on zip codes in Excel. This task can be easily performed by utilizing some Excel functions and ...

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo