Microsoft Office

How To Find Position In Microsoft Excel

To find a position in Microsoft Excel, use Find to locate a cell, MATCH to return a value's position within a row or column, or FIND to locate characters inside text. Use ROW and COLUMN for worksheet coordinates, and ADDRESS to turn row and column.

Which licences fit your PC setup?

Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.

Choose the method for the position you need

A cell address, a position within a list and a character position are different results. Choose the output you need before entering a formula.

Your task Method Result
Locate a value on the worksheet Find Selects a matching cell
Find where a value sits within a list MATCH Position counted from the start of the range
Get a known cell's worksheet coordinates ROW and COLUMN Row number and column number
Build an address from coordinates ADDRESS Address text such as $B$5
Locate text inside a cell FIND or SEARCH Character position within the text

Find a cell containing a value

For a quick search in Excel for Windows, use Ctrl+F. You do not need a formula to locate a name, number or piece of text.

  1. Open the worksheet. Select a range of cells if you want to restrict the search to that area.
  2. Press Ctrl+F and enter the text or number in Find what.
  3. Open Options if you need to change settings. Choose Sheet or Workbook under Within, and select Match entire cell contents if partial matches would be unhelpful.
  4. Select Find Next to move to a match, or Find All to display the matching locations.
  5. Select a result. Close the dialogue box and read the active cell's address in the Name Box, to the left of the formula bar.

For example, searching for Apple may also find Pineapple unless you enable Match entire cell contents. Use Match case when capitalisation matters. Microsoft's Find and Replace guidance explains the available search settings.

Use MATCH for a position within a range

MATCH searches a single row or column and returns a position counted from the first cell of that range. It does not return the cell's contents or its address.

  1. Put the value you want to find in D2.
  2. Select an empty cell outside your data.
  3. Enter =MATCH(D2,A2:A10,0) and press Enter.

If D2 contains Apple and the first matching entry is in A5, the result is 4: A5 is the fourth cell in A2:A10. For a horizontal list, =MATCH(D2,B1:F1,0) returns the position across that row.

Always include the final 0 when you need an exact match. Omitting that argument defaults to an approximate match that requires ascending data. An exact match does not require sorting. MATCH returns the first matching position, ignores differences in capitalisation and returns #N/A when no match exists. See Microsoft's MATCH reference for matching rules.

Convert the position into a worksheet row

When your list starts below row 1, adjust for its starting row:

=MATCH(D2,A2:A10,0)+ROW(A2)-1

In the example above, this returns worksheet row 5. ROW(A2)-1 accounts for the row before the search range. Keep A2 aligned with the first cell of your own lookup range.

Get row numbers, column numbers and addresses

When you already have a cell reference, use ROW and COLUMN to read its coordinates. Enter these formulas in separate empty cells:

  • =ROW(B5) returns 5.
  • =COLUMN(B5) returns 2, because B is the second column.

These functions describe a reference; they do not search for a value. Without a reference, =ROW() and =COLUMN() report the coordinates of the cell containing the formula.

Build a cell address with ADDRESS

ADDRESS takes a row number followed by a column number. For example, =ADDRESS(5,2) returns $B$5. To display B5 without dollar signs, use =ADDRESS(5,2,4). The result is text, rather than a formula that retrieves B5's contents.

You can also combine it with the lookup:

=ADDRESS(MATCH(D2,A2:A10,0)+ROW(A2)-1,COLUMN(A2),4)

If the first match is in A5, this returns A5 as text. The row adjustment converts the relative position into a worksheet row; COLUMN(A2) supplies the column number.

For numeric row-and-column notation, =ADDRESS(5,2,1,FALSE) returns R5C2. Microsoft's ADDRESS reference explains the A1 and R1C1 options. Changing notation is optional when locating data.

Find a character's position inside a cell

FIND searches within text. If A2 contains Order-104, the formula =FIND("-",A2) returns 6 because the hyphen is the sixth character. That number describes the text, not a location on the worksheet.

The syntax is =FIND(find_text,within_text,[start_num]). The optional start_num tells Excel where to begin searching; it defaults to the first character. To find a second hyphen, use:

=FIND("-",A2,FIND("-",A2)+1)

For Order-104-UK, the result is 10. FIND distinguishes uppercase and lowercase letters. Use =SEARCH("order",A2) if case should be ignored. Both functions return #VALUE! when the requested text cannot be found; Microsoft's FIND and SEARCH troubleshooting guide covers this behaviour.

Check unexpected results before using them

  • A position looks too small: check whether MATCH is counting from the start of your range rather than row 1.
  • A match is missing: check for extra spaces and numbers stored as text. Values that look alike may have different underlying contents.
  • Only one duplicate appears: MATCH returns the first match. Use Find All to inspect multiple locations.
  • A lookup returns a name or ID: VLOOKUP and HLOOKUP retrieve related values, rather than automatically returning positions. For example, =VLOOKUP("John",A1:B5,2,FALSE) returns the value from column B on John's matching row. Microsoft's lookup guide explains the distinction.

For related document tasks, the Microsoft Office guides also cover opening a WordPad document in Microsoft Word and repairing Microsoft Word 2010.

Choose one value in your worksheet, locate it with Find, then use an exact MATCH formula on its column and compare the result with the range's starting row.

Other editions for separate workloads

Other editions for separate workloads; prices in AUD, confirm the total on the listing.

How to check this worked

  1. Open Settings, System, Activation and confirm the edition shown.
  2. Enter the key and run activation; expect a green tick within a minute.
  3. Reboot and re-check activation survives the restart.

FAQ

What else should you know before buying?

What do I need before starting?
Read the requirements and confirm the edition first; the steps assume the machine is compatible.
How do I know the licence is genuine?
Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
Is this a subscription?
Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
What if the key fails?
Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.

Check who prepared and reviewed this guide

Written by
MS.Codes editorial
Reviewed by
Support team

Last verified: (source review; see test status above).

Recent Post