# Tag: Lookup Formulas

## How to Use INDEX MATCH

INDEX MATCH is one of several lookup formulas available in Excel. It has certain features that make it superior to VLOOKUP in …

## Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel

I believe, one should ever use LOOKUP functions is you might not know how to use INDEX-MATCH or you might be working …

## Why Do You Need Formulas and Functions?

If you are an office administrator, you probably use Excel. Ditto if you are a salesman. If you are a financial analyst, …

## Excel Formulas: 10 Formulas That Helped Me Keep My Job

Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the …

## How to return multiple values using vLookup in excel

The VLOOKUP function is designed to return only the corresponding value of the first instance of a lookup value. But there is …

## Find max unique value from a range that have duplicate numbers and blanks

Problem: How to find Min and Max numeric values in a range of cells that have duplicate numbers and blanks, but only …

## Learn to Use INDEX MATCH MATCH

What INDEX MATCH MATCH offers you is a more powerful version of the formula. Instead of just a vertical lookup, INDEX MATCH …

## Learn to use HLookup in Excel

HLOOKUP is essentially the horizontal version of VLOOKUP. The primary reason for using HLOOKUP in Excel is for when you have key …

## How to Use VLOOKUP MATCH

VLOOKUP MATCH is one of several possible lookup formulas within Microsoft Excel. This tutorial assumes you already have a decent understanding of …

## How to create relational databases in Excel 2013

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with …