# How Do You Use Vlookup Function In Excel?

On December 12, 2021How do I pull data from another sheet in Excel using Vlookup?

Can you do a VLOOKUP on 2 columns?

**VLOOKUP doesn't handle multiple columns**. You can find matches for Movie and Showtime columns individually but to find a match based on both the columns, you would need to modify the VLOOKUP formula.

How do you do a VLOOKUP with missing values?

## Related Question How do you use Vlookup function in Excel?

### How do you concatenate and VLOOKUP together?

### How do you combine VLOOKUP And if?

### How do I fill in missing data in Excel?

### How do you find missing data in two excel columns?

### How do you find missing data between two Excel sheets?

### What happens when VLOOKUP doesn't find value?

When the range_lookup argument is FALSE—and VLOOKUP is unable to find an exact match in your data—it returns the #N/A error. Also, ensure that the cells follow the correct data type. For example, cells with numbers should be formatted as Number, and not Text.

### How do you do a VLOOKUP If the lookup value is not in the first column?

In order for VLOOKUP to work, the lookup value must be on the left-most column on the table array. If your lookup value is not on the first column of the array, you will see the #N/A error.

### How do I use VLOOKUP Textjoin?

### Can you use VLOOKUP in an if statement?

Did you know that you can use Excel IF statements along with VLOOKUPs? For example, if you wanted to enter a value from a table into a cell, based on what was in another cell, you could start with an IF statement and then enter the VLOOKUP in the “value if true” part of the IF statement.