Function Problems

Return a Left-Adjacent Cell from Another Sheet in Excel

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Create a formula that finds a value in column C of another sheet and returns the corresponding value from column B.

Return a Left-Adjacent Cell from Another Sheet in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
On SheetA, look up a specific value in SheetB column C and return the value immediately to its left.
Observed behavior
The desired result is the column B value from the same row as the match in SheetB column C.
Before you start

Confirm the source sheet name and the rows containing your data. The examples use SheetB rows 2–1000, with the lookup value in SheetA cell D2 and the result in E2.

Solution 1Recommended

Use XLOOKUP to return the value to the left

Use this formula in a version of Excel that supports XLOOKUP.

1
Enter the lookup value

On SheetA, type the value to find in cell D2.

2
Enter the formula

Select SheetA cell E2 and enter =XLOOKUP(D2,SheetB!$C$2:$C$1000,SheetB!$B$2:$B$1000,"").

3
Check the result

Press Enter. Excel returns the corresponding value from SheetB column B, or an empty string if no match is found.

Use XLOOKUP to return the value to the left
First match: If column C contains duplicate matches, XLOOKUP returns the value from the first matching row.
WPS Spreadsheets

Look up a left-adjacent value in WPS Spreadsheets

Use INDEX and MATCH in WPS Spreadsheets to search one sheet and return the corresponding value from a column to its left.

  1. 1. Open your workbook: Open the workbook in WPS Spreadsheets and confirm that the source sheet is named SheetB.
  2. 2. Enter the lookup value: On SheetA, enter the value to find in cell D2.
  3. 3. Add the formula: Select SheetA cell E2 and enter =IFERROR(INDEX(SheetB!$B$2:$B$1000,MATCH(D2,SheetB!$C$2:$C$1000,0)),"").
  4. 4. Check and save: Press Enter to check the returned value, then use File > Save to save the workbook.
Return a value from the same row on another sheet.Open and edit Microsoft Excel XLSX and XLS files.Use familiar spreadsheet formulas in a lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

How do I search for a fixed text value instead of a cell reference?

Replace D2 in either formula with quoted text, such as "Text". For example, use =XLOOKUP("Text",SheetB!$C$2:$C$1000,SheetB!$B$2:$B$1000,"").

What if the source sheet name contains spaces?

Enclose the sheet name in single quotes in each reference. For example, use 'Sheet B'!$C$2:$C$1000 and 'Sheet B'!$B$2:$B$1000.

What happens if there are multiple matches?

The formulas shown return the column B value from the first matching row in the specified ranges.

Why should I limit the lookup ranges?

Using ranges such as B2:B1000 and C2:C1000 instead of entire columns can improve performance. Adjust both ranges to cover your data and keep their starting and ending rows aligned.

How can I copy the formula down for more lookup values?

Enter lookup values in SheetA column D, select the formula cell in column E, and drag its fill handle down. The D2 reference changes for each row, while the dollar signs keep the SheetB ranges fixed.