Look Up a Value in One Excel Column and Return Another
Question details
Find a value in column F and return the corresponding value from column A on the same row.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A lookup value is in C23, and the matching data is in columns F and A.
- Observed behavior
- The user wants a formula that finds an exact match in column F and returns the value from column A on that row.
Confirm that C23 contains the value to find and that the lookup and return ranges cover the same rows. Adjust rows 1–18 in the formulas if your data uses a different range.
Use XLOOKUP to Return the Matching Value from Column A
Use XLOOKUP if your Excel version supports it and you want a concise exact-match formula.
Click an empty cell where you want the matching value from column A to appear.
Type =XLOOKUP(C23,$F$1:$F$18,$A$1:$A$18,"Not found") in the cell or formula bar, then press Enter.

Use INDEX and MATCH in Older Excel Versions
Use this formula when XLOOKUP is unavailable or you need a widely supported alternative.
Return a Matching Column Value in WPS Spreadsheet
Use INDEX and MATCH in WPS Spreadsheet to find a value in column F and return the corresponding value from column A.
- 1. Open the spreadsheet: Open WPS Spreadsheet and use Open to select your Excel workbook.
- 2. Check the lookup value: Enter or confirm the value to find in cell C23, and check that columns F and A contain the corresponding data.
- 3. Enter the formula: Click an empty result cell and enter =IFERROR(INDEX($A$1:$A$18,MATCH(C23,$F$1:$F$18,0)),"Not found").
- 4. View the result: Press Enter to display the matching value from column A, then use Save to keep your changes.

Frequently Asked Questions
Can VLOOKUP return a value from a column to the left?
A standard VLOOKUP searches the first column of its table and returns a value from a column to its right. To search column F and return column A, use XLOOKUP or INDEX and MATCH instead.
What happens if column F contains duplicate values?
The formulas shown return the column A value for the first matching entry in F1:F18.
Why does the formula show "Not found" when the value appears to exist?
Check that C23 and the cells in F1:F18 contain matching data types and do not have extra spaces. For the INDEX and MATCH formula, also check for other formula errors because IFERROR masks those as "Not found".
How do I search more than 18 rows?
Change both ranges to cover the same rows. For example, replace $F$1:$F$18 with $F$1:$F$100 and $A$1:$A$18 with $A$1:$A$100.




