Thread: 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

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

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" <Wato2@discussions.microsoft.com> wrote in message
news:38154DBC-2A20-4F27-AC53-294EA738A5A2@microsoft.com...
> 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

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



<Wato2@discussions.microsoft.com> wrote in message
news:38154DBC-2A20-4F27-AC53-294EA738A5A2@microsoft.com...
> 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