## How to use VLOOKUP wildcard in Excel (partial text match)

By |2019-06-16T09:19:51+00:00April 21st, 2019|

If you are reading this, I guess you already know how the VLOOKUP function works. This function is so sensitive that it can detect even trailing and leading spaces in a cell – something the human eye can barely see. What if you are [...]

## The three main VLOOKUP Limitations in Excel

By |2019-05-22T06:09:55+00:00April 20th, 2019|

VLOOKUP is one of the popular functions in Excel. It is very helpful to many Excel users who want to look and retrieve information from a table (or dataset). As important as it is, VLOOKUP isn’t flawless. It possesses some limitations. If you know [...]

## How to show cell formulas in Excel

By |2019-05-01T18:55:43+00:00April 19th, 2019|

How to show cell formulas in Excel is one of the frequently asked questions about formulas. As soon as you enter a formula in a cell, Excel shows the calculated values rather than the formula text. This behavior is usually what you want to [...]

## VLOOKUP to the left – (Using INDEX-MATCH)

By |2019-05-01T18:55:55+00:00April 19th, 2019|

Before we begin, make sure to download the left lookup example file below: Download Example File VLOOKUP is very useful for finding and retrieving related information in a table (or dataset). This function isn’t perfect though. It suffers from certain limitations. One [...]

## VLOOKUP not working – Solved with Examples

By |2019-05-01T18:56:04+00:00April 18th, 2019|

Want to know why your VLOOKUP is not working? You are in the right place. This tutorial will help you learn why you are getting VLOOKUP errors in Excel 2019, 2016, 2013, 2010 and 2007. Introduction Most of the Excel gods consider VLOOKUP as [...]

## Excel MATCH function Explained (with examples)

By |2019-06-24T16:47:38+00:00April 7th, 2019|

What is MATCH function in Excel? The MATCH function is used to search for a value in a range in order to retrieve the position of a cell that matches the search term. Assuming you have a list of names in a column, the [...]

## Excel INDEX function explained (with examples)

By |2019-05-01T18:57:04+00:00April 7th, 2019|

In this step by step tutorials, you’ll learn how to use the INDEX function in Excel, with a clear syntax break-down and step by step examples demystified. What is INDEX function in Excel? INDEX function retrieves a cell value from a range of cells, [...]

## How to do a Double lookup in Excel (Two-way lookup)

By |2019-05-01T18:58:16+00:00April 6th, 2019|

What is a double lookup in Excel? Two-way lookup or double lookup is simply a formula that looks in both vertical and horizontal directions simultaneously, in order to find a cell where a specific column and a row intersect. If only VLOOKUP() and HLOOKUP() [...]

## Over 10 Actionable VLOOKUP Examples Explained

By |2019-06-22T23:01:17+00:00April 6th, 2019|

As we all know, the best way to learn something is to get your hand on it, make mistakes and learn from them. As they say, practice makes a man perfect. That’s what this Excel VLOOKUP Example guide is all about. I believe that [...]