Return a Left-Adjacent Cell from Another Sheet in Excel
Question details
Create a formula that finds a value in column C of another sheet and returns the corresponding value from column B.

- 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.
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.
Use XLOOKUP to return the value to the left
Use this formula in a version of Excel that supports XLOOKUP.
On SheetA, type the value to find in cell D2.
Select SheetA cell E2 and enter =XLOOKUP(D2,SheetB!$C$2:$C$1000,SheetB!$B$2:$B$1000,"").
Press Enter. Excel returns the corresponding value from SheetB column B, or an empty string if no match is found.

Use INDEX and MATCH in older Excel versions
Use this alternative if your Excel version does not support XLOOKUP.
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. Open your workbook: Open the workbook in WPS Spreadsheets and confirm that the source sheet is named SheetB.
- 2. Enter the lookup value: On SheetA, enter the value to find in cell D2.
- 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. Check and save: Press Enter to check the returned value, then use File > Save to save the workbook.

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.




