Matching cell information

[Wato2]

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.

 

[Bondi]

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.

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

 

[Bob Phillips]

or maybe just INDEX

=INDEX(Sheet2!A:A,A2)

and

=INDEX(Sheet2!B:B),A2)

where A2 is where the number is entered.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[charles]

I would use an area around the bottom of my spread sheet and use dsum for
each different cow Have a column with cow type number in. then set up
your data base at the bottom for information on that cow type
charles