Function Problems

Match a Name and Return Its Ticker in Excel

Bushra ParveenBushra Parveen Nov 18, 2026 868 views

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.

How to Match a Name and Return Its Ticker in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a result cell

Click an empty cell where you want the ticker to appear, such as J7.

2
Enter the formula

Type =IFERROR(INDEX($E$7:$E$22,MATCH(I7,$F$7:$F$22,0)),"") in the selected cell and press Enter.

3
Fill down if needed

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 INDEX and MATCH to return the ticker
How the formula handles errors: MATCH finds the position of the first exact match, and INDEX returns the ticker at that position. IFERROR displays a blank for any formula error, including a missing match.
WPS Spreadsheets

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. 1. Open your spreadsheet: Open WPS Spreadsheets and choose Open to select your workbook.
  2. 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. 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. 4. Fill and save: Drag the result cell's fill handle down for additional names, then choose Save to keep the changes.
Match names to tickers using an exact lookup formulaOpen and edit Microsoft Excel XLS and XLSX filesUse a familiar spreadsheet interface to fill formulas downWork with spreadsheets using the free WPS Office suite
microsoft office alternative - wps office

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.