## Best Excel Tutorial

The largest Excel knowledge base ✅ The best place to learn Excel online ❤️

#### Vlookup for a range of values

Vlookup is a powerful function in Excel that can be used to search for a specific value in a range of cells and return a corresponding value from a different column in the same row. Doing vlookup for a range of values is also possible.

Here you have an example which shows you how to deal with vlookup for a range in Excel.

#### Vlookup across multiple files

The VLOOKUP function is a powerful tool in Excel that can be used to lookup values in a table. However, the VLOOKUP function can only lookup values in a single table at a time.

#### Vlookup on Multiple Sheets

There are situations when you have data on many sheets. In this lesson you will teach yourself how to do vlookup in this case.

#### How to do a Vlookup Using Text

In this Excel tutorial, you learn how to vlookup using string of text. This is a simple trick you will understand and use many times in Excel.

#### How to Vlookup Backwards

Something tricky today. Let’s create some backwards VLOOKUP formula. It’s quite easy, but not obvious. Here’s an example.

#### How to Use Vlookup with a Drop Down List

Let’s expand your drop-down list using this simple trick in Excel. Teach yourself here how to automatically load the values into the drop-down list using VLOOKUP function.

#### How to do a Vlookup with Multiple Criteria

In this Excel tutorial, you will learn how to do a vlookup with multiple criteria in Excel.

#### How to Countif with Partial Match

In this Excel tutorial, you will learn how to countif cells with partial match in Excel. The efficiency of using the countif partial text is its contribution to a productive end-result.

#### How to Use Linest Function in Excel

The Linest function helps you figure out statistics for a single line in your data. It does this by using something called “least squares” to find a straight line that matches your data closely.

Then, it gives you a set of numbers that describe that line. It does all this by taking data you put into the Linest formula and giving you back the results in an array.