Excel - Check a specific value within a range

April 2018


I need a formula that can check a specific value in a range of values and show the cell location for each time the value is find

Suppose Serial No is in column A1 to A20, and data range is in B1 to B20.


There are many ways of doing it
  • Highlight B1 t0 B20
  • Edit -find(or control +F).

Against find what type
  • And click findall

you will get below find dialog box

that means serial nos. are 2,5,9
  • Another way:
    • In C1 or in any empty cell in that row 1 type this formula:

  • Copy C1 down up to C20 and see what happens.


Thanks to venkat1926 for this tip on the forum.
Published by aakai1056. Latest update on December 14, 2011 at 04:29 AM by aakai1056.
This document, titled "Excel - Check a specific value within a range ," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel – Copy to next blank line
Excel - Automatically fill-in dates