Find a Name in Excel: Search and Match Methods

Formulas & functions · Updated November 20, 2026

To find a name in an Excel sheet, press Ctrl+F on Windows, type the name, and press Enter or choose Find Next; on a Mac, press Command+F. To search every worksheet or check names with a formula, change the search scope or use a matching function such as COUNTIF or MATCH.

Find a name with Excel’s Find dialog

The Find dialog is the quickest choice when you want to locate a name without changing the worksheet. In Excel for Microsoft 365 on Windows, press Ctrl+F, or go to Home > Find & Select > Find. Enter the name in the Find what box, then choose Find Next. Excel moves to a cell containing that text. Choose Find Next again to move to the next occurrence.

If the name appears several times, choose Find All instead. Excel displays a list of matching cells, including their worksheet and cell references when you search the workbook. Select a result in the list to jump to that cell. This is useful for checking duplicate entries or seeing whether a name appears in more than one place.

  • To search a particular range, select the range before opening Find. Excel searches the selection rather than the entire sheet.
  • To search the whole current sheet, click a single cell or press Esc to clear a multi-cell selection before searching.
  • Use Find Next for a quick scan, or Find All when you need to review every occurrence.

Excel can remember search settings from a previous search. If a name that you can see is not found, open Options in the Find dialog and check the scope, match settings, and Look in setting before concluding that the entry is missing.

Search every worksheet in the workbook

By default, Find searches the active worksheet. To search all worksheets in the open workbook, press Ctrl+F, choose Options, and change Within from Sheet to Workbook. Then enter the name and use Find Next or Find All. The Workbook setting can save time in files with separate tabs for departments, months, or locations.

Check the workbook scope before interpreting results. If Within is set to Sheet, Excel will not report a name stored only on another tab. Conversely, a workbook-wide search may find several matches on different tabs, so review the sheet and cell reference for each result. Search order can also be set to By Rows or By Columns in the dialog; that controls the order in which Excel visits matches, not which cells qualify.

On a Mac, Command+F opens Find. The dialog and available options can vary slightly by Excel version, but look for the scope setting that switches between the active sheet and the workbook. If you are using Excel in a browser, use Excel’s own Find command rather than relying on the browser’s separate page-search shortcut, which may search only content currently rendered in the browser.

Choose exact or partial matching

A search for Maya Chen can find a cell that contains only Maya Chen, but it can also find that text inside a longer cell, such as Maya Chen — Sales. If you need a complete-cell match, open Options and select Match entire cell contents. If you want Excel to distinguish uppercase from lowercase, select Match case. These settings are helpful when a partial match or a capitalization difference would create misleading results.

Partial searches are useful when you remember only part of a name. Searching for Chen, for example, can locate Maya Chen and Jordan Chen. A short search term can return unrelated matches, however: searching for Ann might find Ann Lee, Joanne Patel, or a longer word containing those letters. Add a surname, initial, or other identifying text when the result list is too broad.

Find is a text search, not a people-matching system. It does not know that “M. Chen” and “Maya Chen” might refer to the same person, and it will not automatically treat spelling variations as equivalent. If your list has inconsistent formats, standardize the entries or search for a distinctive part of the name, then inspect the surrounding data before deciding that two records belong to the same person.

Use a formula to check whether a name appears

Use a formula when you want a result that updates as the worksheet changes, rather than a one-time jump to a cell. For example, with names in A2:A100 and the name to check in D2, enter:

=COUNTIF(A2:A100,D2)

If “Maya Chen” occurs twice in A2:A100 and D2 contains Maya Chen, the formula returns 2. A result of 0 means there is no matching cell under COUNTIF’s matching rules. COUNTIF is case-insensitive, so it treats Maya Chen and MAYA CHEN as the same text. It also recognizes wildcard characters in the criteria: an asterisk can stand for any number of characters, and a question mark can stand for one character. If a name itself contains those characters, the result may not mean what you expect.

To find the position of the first exact match in a list, use MATCH. With the same layout—names in A2:A100 and the lookup name in D2—enter:

=MATCH(D2,A2:A100,0)

If the first matching name is in A7, the formula returns 6, because A7 is the sixth item in the range A2:A100. It returns the position within the range, not the worksheet row number. The final argument, 0, requests an exact match. If the name occurs more than once, MATCH returns the position of the first occurrence.

For a test of whether a fragment appears inside a cell, with the text to search for in D2 and the name in A2, use:

=ISNUMBER(SEARCH(D2,A2))

If D2 contains Chen and A2 contains Maya Chen, the formula returns TRUE. SEARCH ignores capitalization, so it also finds chen in Maya Chen. For a case-sensitive substring test, Excel has the FIND function, which is case-sensitive; it returns a position when it finds the text and an error when it does not. SEARCH and FIND test text within a cell, while MATCH and COUNTIF are better suited to checking a list of entries.

Find a name and return related information

Sometimes locating a name is only the first step: you may also need the person’s department, phone extension, or order total. XLOOKUP can return a value from a neighboring column. With names in A2:A100, departments in B2:B100, and the requested name in D2, enter:

=XLOOKUP(D2,A2:A100,B2:B100)

If Maya Chen is the first match in the names column and the corresponding department in column B is Operations, the formula returns Operations. XLOOKUP is available in Microsoft 365 and Excel 2021 or later. It returns the first match by default; if names are duplicated, confirm that returning the first record is appropriate or use an additional identifier, such as an employee number. MATCH, XLOOKUP, and related lookup formulas do not determine whether two differently written names refer to the same person.

Why Excel may not find a visible name

A missed result often comes from a search setting or a difference in the underlying cell contents. Check these issues before retyping or replacing data:

  • Wrong scope: The dialog is set to Sheet when the name is on another tab, or a range is selected and the search is limited to it.
  • Wrong Look in setting: A cell may display a name because a formula returns it. Searching in formulas may look for the formula text rather than the displayed result. Choose Values when you want to search the calculated or displayed text; choose Formulas when you want to inspect formula contents.
  • Whole-cell matching is on: A search for Maya will not match a cell containing Maya Chen when Match entire cell contents is selected.
  • Case matching is on: A case-sensitive search can miss text with different capitalization.
  • Extra spaces or characters: A leading space, trailing space, nonbreaking space, or copied punctuation can make an entry different from the name you typed.
  • Different spelling or format: A middle initial, accent, hyphen, or shortened first name may make the stored text unlike the search term.

For example, a cell that appears to contain “Maya Chen” may actually contain a trailing space. A search with Match entire cell contents may not behave as expected if the typed text and stored value differ. To inspect a suspicious entry, select the cell and look at the formula bar. If the text needs cleanup, make a copy of the source column first; bulk replacements can alter legitimate names as well as accidental spaces.

Use filters for repeated name searches

If you regularly review a list rather than look up one name once, a filter can be more convenient than reopening Find. Select a cell in the data range and choose Data > Filter. Open the dropdown in the name column and type a name in its search box, or select the relevant value. Excel filters the displayed rows to show matching records while leaving the underlying data in place.

Filters are especially useful when you need to inspect other fields in each matching row, such as location or status. They are not the same as Find: a filter presents matching records as a set, while Find jumps to matching text. Clear the filter when finished to show the other rows again. If the data is formatted as an Excel table, its column headers normally include filter controls when filtering is enabled.

Frequently Asked Questions

How do I find a name in an Excel sheet quickly?
Press Ctrl+F on Windows or Command+F on a Mac, type the name, and choose Find Next. Use Find All if you want a list of every occurrence.

How do I search all sheets in Excel at once?
Open Find, choose Options, and set Within to Workbook instead of Sheet. Find All then lists matches from the workbook’s worksheets.

Can Excel find part of a name?
Yes. Search for a distinctive fragment such as a surname. To require a complete-cell match, turn on Match entire cell contents in the Find options.

How do I find duplicate names?
Use Find All to inspect occurrences of a particular name, or use COUNTIF to count a name in a range. With names in A2:A100 and the name in D2, =COUNTIF(A2:A100,D2) returns the number of matching cells.

Why does Excel say a name is not found when I can see it?
Check whether Excel is searching the selected range or the wrong worksheet, whether Look in is set to Formulas instead of Values, and whether whole-cell or case matching is enabled. Also check for extra spaces and spelling differences.

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.