You can use the **XLOOKUP** function in Excel to look up a specific value in a range and return the corresponding value in another range.

You can use the following syntax with **XLOOKUP** to look up a value from one sheet and return the corresponding value from another sheet:

=XLOOKUP(A2, Sheet2!$A$2:$A$11, Sheet2!$B$2:$B$11)

This particular formula looks up the value in cell **A2** of the currently active sheet in the range **A2:A11** of **Sheet2** and returns the corresponding value in the range **B2:B11** of **Sheet2**.

The following example shows how to use this syntax in practice.

**Example: How to Use XLOOKUP From Another Sheet**

Suppose we have one sheet called **Sheet1** that contains information about the points scored by basketball players on various teams:

Suppose we have another sheet called **Sheet2** that contains information about the assists for basketball players on various teams:

Suppose we would like to look up the team names in **Sheet1** within **Sheet2** and return the value from the **Assists** column.

We can type the following formula into cell **C2** of **Sheet1** to do so:

=XLOOKUP(A2, Sheet2!$A$2:$A$11, Sheet2!$B$2:$B$11)

We can then click and drag this formula down to each remaining cell in column C:

The **XLOOKUP** function returns the value in the **Assists** column from **Sheet2** that corresponds to the value in the **Team** column from **Sheet1**.

For example, if we check **Sheet2** we will see that the Mavs do indeed have a value of 5 in the **Assists** column.

**Note**: You can find the complete documentation for the **XLOOKUP** function in Excel here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Use XLOOKUP with IF Statement

Excel: How to Use XLOOKUP to Return All Matches

Excel: How to Use XLOOKUP with Multiple Criteria