If you mean you want to enter 2001 in cell A1 and have "Omagh"
magically appear in its place when you hit the return key, I don't
think it can be done.

However, if you enter 2001 in cell A1 and have a VLOOKUP formula in
cell B1, with reference data stored elsewhere in the sprdsht, that is
easily done.