Function Problems

Look Up a Value in One Excel Column and Return Another

Olivia MillerOlivia Miller Nov 18, 2026 870 views

Question details

Find a value in column F and return the corresponding value from column A on the same row.

Look Up a Value in One Excel Column and Return Another
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a result cell

Click an empty cell where you want the matching value from column A to appear.

2
Enter the XLOOKUP formula

Type =XLOOKUP(C23,$F$1:$F$18,$A$1:$A$18,"Not found") in the cell or formula bar, then press Enter.

Use XLOOKUP to Return the Matching Value from Column A
XLOOKUP availability: XLOOKUP is available in Microsoft 365 and Excel 2021 or later. If your version does not support it, use INDEX and MATCH instead.
Look up values in WPS Spreadsheet

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. 1. Open the spreadsheet: Open WPS Spreadsheet and use Open to select your Excel workbook.
  2. 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. 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. 4. View the result: Press Enter to display the matching value from column A, then use Save to keep your changes.
Look up values to the left of the search columnUse an exact match and display a message when the formula returns an errorOpen and edit Microsoft Excel XLSX and XLS filesWork with a familiar spreadsheet interface
microsoft office alternative - wps office

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.