How to speed up lookup formulas

Lookup functions are extremely useful when working with large data sets. Although they almost always work instantaneously with small data, larger data sets is when things can get rough in terms of performance, as large operations can require more computational power....
Function: VLOOKUP

Function: VLOOKUP

VLOOKUP function is a lookup and reference function that can search a specific information in a table. In this guide, we’re going to show you how to use the VLOOKUP function and also add some tips and error handling methods. The VLOOKUP searches a value in the first...
How to get nth match with VLOOKUP

How to get nth match with VLOOKUP

This article shows you how to get the nth match with VLOOKUP formula. Unfortunately, Excel doesn’t have a built-in function to find any value beyond the first match. Syntax Unique lookup value: =lookup value & COUNTIF(expanding range of lookup values, lookup...