Match a Name and Return Its Ticker in Excel
Question details
Find a name in one column and return its corresponding ticker from another column, leaving the result blank when there is no match.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A worksheet contains names in F7:F22, corresponding tickers in E7:E22, and a name to look up in I7.
- Observed behavior
- The desired result is the ticker from the matching row, or a blank cell if the name is not found.
Check that names are in F7:F22 and their corresponding tickers are in the same rows of E7:E22. Adjust the ranges and lookup cell in the formulas if your worksheet uses different locations.
Use INDEX and MATCH to return the ticker
Use this formula to find an exact name match and return the ticker from the column to its left.
Click an empty cell where you want the ticker to appear, such as J7.
Type =IFERROR(INDEX($E$7:$E$22,MATCH(I7,$F$7:$F$22,0)),"") in the selected cell and press Enter.
Drag the cell's fill handle down to look up names in the rows below I7. The dollar signs keep the ticker and name ranges fixed.

Use XLOOKUP to find the ticker
Use XLOOKUP for a shorter formula in Microsoft 365 or Excel 2021.
Find matching tickers with WPS Spreadsheets
Use INDEX, MATCH, and IFERROR in WPS Spreadsheets to return a ticker for each name and leave missing matches blank.
- 1. Open your spreadsheet: Open WPS Spreadsheets and choose Open to select your workbook.
- 2. Check the lookup ranges: Confirm that tickers are in E7:E22, names are in F7:F22, and the name to find is in I7. Adjust the formula ranges if needed.
- 3. Enter the lookup formula: Click an empty result cell and enter =IFERROR(INDEX($E$7:$E$22,MATCH(I7,$F$7:$F$22,0)),""). Press Enter.
- 4. Fill and save: Drag the result cell's fill handle down for additional names, then choose Save to keep the changes.

Frequently Asked Questions
What happens if a name is not in the lookup column?
MATCH returns an error when it cannot find the name. The surrounding IFERROR function replaces that error with a blank result.
What if the same name appears more than once?
MATCH with 0 returns the position of the first exact match, so INDEX returns the ticker from that first matching row.
Why is a name returning a blank even though it appears in the list?
Check the lookup cell and the entries in F7:F22 for extra spaces or spelling differences. Also confirm that the formula points to the correct name and ticker ranges.
Why are there dollar signs in the ranges?
The dollar signs make E7:E22 and F7:F22 absolute references, so those ranges stay fixed when you drag the formula down. The I7 reference changes to I8, I9, and so on.




