Finding Names in Excel: Search, Filter, and Match Quickly

Formulas & functions · Updated November 20, 2026

To find a name in Excel, press Ctrl+F, type the name, and choose Find Next or Find All; use the Find dialog’s options to search the whole workbook or match the entire cell. To locate names in a list repeatedly, use filters or a formula instead of searching one at a time.

Choose the right way to find a name

The best method depends on what you mean by “find.” If you know a name and want to jump to a cell containing it, Find is fastest. If you need to narrow a long list to people whose names meet a condition, use a filter. If you need to check many names against a master list or return related information, a formula is more repeatable.

  • Find: locate a known name or text within a sheet or workbook.
  • Filter: display only rows that match a name or name pattern.
  • Formula: test whether names exist, return matching details, or produce a list of matches.
  • Name Manager: inspect workbook-defined names, which are different from people’s names in cells.

Before searching, check where the names are stored. A name may be in a single column, embedded in a longer note, or part of a formula result. That distinction affects which search setting or formula will work.

Find a name with Excel’s Find command

In Excel for Microsoft 365 on Windows, press Ctrl+F to open Find and Replace. Type all or part of the name in the Find what box, then select Find Next to move through matches. Select Find All to display every matching cell in the results list; selecting a result takes you to that cell. You can also use Home > Find & Select > Find.

Use the Options button in the dialog when a basic search misses something or returns too many results. The most useful settings are:

  • Within: choose Sheet to search the current worksheet or Workbook to search across sheets.
  • Search: choose By Rows or By Columns to control the order Excel checks cells.
  • Look in: choose Values to search displayed results or Formulas to search formula contents. For example, a cell displaying “Maya Chen” might contain a formula that refers to another cell.
  • Match case: turn this on only if capitalization matters to your search.
  • Match entire cell contents: use this when a cell should contain the name and nothing else. Without it, searching for “Ann” can also find “Annette.”

Find remembers some settings from earlier searches, so check them if a familiar search suddenly behaves differently. To search for “Ann” as a separate whole-cell value, enable Match entire cell contents. To find it inside “Ann Lee” or “Contact: Ann,” leave that option off.

Search for part of a name or a text pattern

Excel’s Find command supports wildcards. Use an asterisk (*) for any number of characters and a question mark (?) for one character. Searching for Mar* can find cells starting with “Mar,” such as “Maria” or “Mark.” Searching for J?n can find “Jan” or “Jon.” These patterns are useful for spelling variations, but they can also return unintended matches; review the results rather than assuming every match is the person you mean.

To search for a literal asterisk, question mark, or tilde, place a tilde (~) before it. For instance, ~* searches for an actual asterisk rather than treating it as a wildcard. This matters when a cell contains symbols as part of a code or label.

Find is not the same as a flexible “contains” formula. If you want to test whether a text cell includes a name fragment, SEARCH can return the fragment’s position. With comments in A2:A20 and the text to check in B2, use =ISNUMBER(SEARCH(B2,A2)) in C2 and fill down. If A2 is “Call Maya Chen,” and B2 is “Maya,” the result is TRUE. SEARCH ignores capitalization; FIND performs a case-sensitive text search instead. These formulas check one row at a time, so adjust the cell references to suit your data.

Filter a list to show matching names

Filtering is useful when names are arranged in a table with related information, such as department, email address, or order number. Click a cell in the data range and choose Data > Filter. Excel adds drop-down arrows to the header row. Open the arrow on the name column, clear Select All, select the name or names you want, and choose OK. The other columns stay attached to their original rows, while rows that do not match are temporarily hidden.

For a larger list, use the filter search box to type a name or a fragment. Text filters can also show entries that begin with, contain, or end with particular text. Filtering changes what is visible; it does not delete the other records. Clear the filter from the column menu or choose Data > Clear to show the full list again.

For reliable results, make sure the list has a clear header row and avoid blank rows splitting the data. Converting a range to a table with Ctrl+T can make filtering and later expansion easier. If multiple people share a name, include another identifying column, such as an email address or employee number, before deciding which row is the right one.

Check whether names appear in another list

A formula can compare a list of names against a master list and label each one as found or missing. With the master names in A2:A100 and names to check in E2:E20, enter this in F2 and fill down:

=COUNTIF($A$2:$A$100,E2)>0

If E2 contains “Maya Chen” and that name appears at least once in A2:A100, the result is TRUE; otherwise it is FALSE. The dollar signs keep the master range fixed as you copy the formula down. COUNTIF is not case-sensitive, and it recognizes wildcard characters in its criteria, so a name containing * or ? may need special handling. It also counts exact cell values by default here: “Maya” is not a match for a cell containing “Maya Chen.”

If you want Excel to return a related value rather than TRUE or FALSE, use XLOOKUP. With names in A2:A100, email addresses in B2:B100, and the name to look up in E2, enter:

=XLOOKUP(E2,A2:A100,B2:B100,"Not found",0)

If E2 is “Maya Chen” and the corresponding email in column B is maya@example.com, the formula returns that email; if there is no exact match, it returns “Not found.” The final 0 requests an exact match. XLOOKUP is available in Microsoft 365 and Excel 2021 or later, but not in older perpetual versions such as Excel 2019. A person’s name is not always unique, so use a more distinctive lookup key where possible.

Return every matching row with a formula

When you need all rows for a name rather than the first match, FILTER can return multiple results in supported versions of Excel. With names in A2:A100, email addresses in B2:B100, and the name to search for in E2, enter:

=FILTER(A2:B100,A2:A100=E2,"No match")

If E2 is “Maya Chen” and two rows have that exact name, the formula spills both matching rows, including the corresponding email addresses, into nearby cells. Make sure the spill area is empty; existing content can cause a #SPILL! error. FILTER is available in Microsoft 365 and Excel 2021 or later. In an older Excel version, use the filter drop-down or an appropriate lookup method instead.

These formulas compare cell values, not a person’s identity. Two people can have the same name, and an extra space or different spelling can make apparently similar entries fail an exact comparison. For sensitive records or important decisions, verify matches with a stable identifier such as an email address or ID number.

Fix common name-search problems

Names that look identical on screen may contain different spaces or characters. A copied name can include leading or trailing spaces, nonbreaking spaces, or a different apostrophe or hyphen. If Find or an exact formula returns no match, compare the underlying values and check for these differences. TRIM removes ordinary extra spaces at the beginning and end and reduces repeated spaces between words, but it does not remove every special whitespace character.

For a cleaned helper column, with the original names in A2:A100, enter =TRIM(A2) in B2 and fill down. If A2 contains “ Maya Chen ” with ordinary spaces, B2 displays “Maya Chen.” Keep the original data until you have confirmed the cleanup is correct. For imported data with unusual characters, a simple TRIM formula may not be enough; inspect or clean the source values before relying on exact matches.

Also check whether the name is in a hidden or filtered-out row, whether the search is limited to the current sheet, and whether Look in is set appropriately. A formula-generated display value may require searching Values rather than Formulas. If capitalization is the only difference, remember that Find and COUNTIF are generally not case-sensitive, while the FIND function is case-sensitive.

People’s names versus Excel defined names

Excel also uses the word “name” for a defined name: a label assigned to a cell, range, formula, or constant. For example, a workbook might define TaxRate to refer to a particular cell. That is separate from a person named in a worksheet cell. To inspect defined names in Microsoft 365 for Windows, choose Formulas > Name Manager, or press Ctrl+F3. The Name Manager shows names and what they refer to; it is not a search tool for people in a contact list.

On Mac, use Command+F to open Find, then use the same Find dialog options where available. Ribbon wording and dialog details can vary slightly by Excel release. In Excel for the web, use the search command or browser-style Find where available, but remember that a browser search may not offer all workbook-wide options found in desktop Excel. For defined names, look for Name Manager on the Formulas tab if it is available in your web version; otherwise open the workbook in desktop Excel.

Frequently Asked Questions

How do I find a name in all Excel sheets?
Press Ctrl+F, choose Options, set Within to Workbook, type the name, and select Find All. The results list helps you move between matching cells on different worksheets.

How do I find an exact name instead of part of a name?
Open Find options and select Match entire cell contents. This prevents a search for “Ann” from returning a cell containing “Annette.”

Can Excel find a name inside a sentence?
Yes. Use Find with Match entire cell contents turned off, or use SEARCH in a formula to test whether text contains a name fragment. SEARCH is not case-sensitive.

How do I find duplicate names in Excel?
Use Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values to highlight repeated cell values in a selected range. Confirm that names are truly duplicates: two people can share a name, and small spelling or spacing differences can prevent a match.

Why can’t Excel find a name that is visibly in the sheet?
Check whether the search is limited to the wrong sheet, whether Match entire cell contents or Match case is enabled, and whether Look in is set to Formulas instead of Values. Extra spaces or different characters can also cause a mismatch.

How do I find a name in an older version without XLOOKUP?
Use Ctrl+F, filter the name column, or compare entries with COUNTIF. XLOOKUP requires Microsoft 365 or Excel 2021 and later; Excel’s Find and filter tools are suitable for many tasks in older versions.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.