Wato2 wrote:
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

Hi Wato2,

I'm not really sure what you are looking for but it sounds like you can
use the VLOOKUP() function.
On this link there is a really good guide to using it:

http://www.contextures.com/xlFunctions02.html

Good luck,
Regards,
Bondi