Matching cell information
 

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

Matching cell information
 

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

Matching cell information
 

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)

"Wato2" wrote in message
...
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

Matching cell information
 

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



wrote in message
...
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