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
Against find what type
you will get below find dialog box
that means serial nos. are 2,5,9
Thanks to venkat1926 for this tip on the forum.