I am trying to setup a work sheet so that when we weigh cattle, I can enter a
number into a cell and this then matches to a breed, eg. Enter '1', this
should be 'Murrey Grey female'.

I have setup the page and on another worksheet I have listed the breeds and
sexes in a numerical order going down columns; however, I don't know how to
get the cell to recognise that 1 equals Murrey Grey female

There are a total of 23 breeds with each breed having both female and males.
--
Thanks for any help that can be offered,

Wato2