VLOOKUP Articles: Excel and Google Sheets

The VLOOKUP function is very powerful. However, it has some restrictions which is why INDEX MATCH is the game changer. This tutorial will walk through the VLOOKUP restrictions and why INDEX MATCH is a better solution Final Formula =INDEX(A3:B8,MATCH(E2,B3:B8,0),1) Figure 1 - Final result The VLOOKUP function has three main...

The VLOOKUP function is very powerful but it can often return the #N/A error message for many different reasons. This article will step you through the troubleshooting process when a VLOOKUP function returns a #N/A error Check for Spelling, Capitalization and Extra Spaces If either the lookup value or lookup...

By Locking the VLOOKUP from a table array, we can quickly reference a set of data against multiple lookup values. This tutorial will give you step by step instructions on how to lock the VLOOKUP table Final formula: =VLOOKUP(D3,$A$3:$B$11,2,FALSE) Setting up the Data In this example the owner of Icy Treats...

It is very simple to automatically generate a new date value each day. By using the TODAY function, Excel users of all levels will be able to automatically reference the current date each day after reviewing this tutorial Final Formula: TODAY() Applying the TODAY function We can automatically generate the current...

While using the VLOOKUP function in Excel, we will often need to lookup a value based on two criteria. This is possible by modifying the lookup value in the standard VLOOKUP function. In this tutorial, we will learn how to apply VLOOKUP with two criteria. Figure 1. Final result Syntax...

While working in Excel, we often need to get a value from a table based on a specific value. In this tutorial, we will compare the VLOOKUP and HLOOKUP functions and walk through examples of the when to use each Syntax of the VLOOKUP formula The generic formula for the...

The VLOOKUP is one of the most popular functions in Excel. However, there can be many errors while using this function. In this tutorial, we will learn what to do if you’re getting a #REF! error with VLOOKUP. This error appears when data is missing or when we use a...

While using the VLOOKUP function in Excel, we sometimes need to apply it to a range. This is possible by using an absolute cell reference. In this tutorial, we will learn how to quickly copy a VLOOKUP formula down a column. Figure 1. Final result Syntax of the VLOOKUP formula...

While using the standard VLOOKUP function in Excel, a lookup value must be in the leftmost column of a table. In this tutorial, we will learn how to look up for the value even if it is not in the leftmost. In order to do this, we can use the...

While working in VLOOKUP function in Excel, we may need to look up for values in multiple tables. This is possible by nesting VLOOKUP function. In this tutorial, we will learn how to nest VLOOKUP function in order to look up for a value. Setting up Your Data Figure 1....