# VLOOKUP Articles: Excel and Google Sheets

All resources related to VLOOKUP for Excel and Google Sheets.

### VLOOKUP

VLOOKUP vs. Index Match: Which Is More Efficient?
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...
What to Do if You’re Getting an #N/A Error with VLOOKUP
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...
How to Lock a VLOOKUP from a Table Array
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...
How to Get a Date to Automatically Update in Excel
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...
How to Apply VLOOKUP with Two Criteria (plus Formula Examples)
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...
VLOOKUP vs. HLOOKUP: When to Use Each Formula
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...
What to Do if You’re Getting a #REF Error with VLOOKUP
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...
How to Copy a VLOOKUP Formula Down a Column
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...
How to Make VLOOKUP Reference Left Column in Excel
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...
Nested VLOOKUP Formula Examples
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....
1 2 3 4 5