You can give a cell or range of cells a unique name which can then be used in formulas or to find cells.
To create a named range, select the cell(s) that you want to apply a name to. Then click in the Name Box and type in the name you want to give the cell(s). Once you have done that press enter.
Named ranges must have a unique name.