T
tonycalvo
Hi there;
I am trying to use a list of 32 items that may be inserted in a cell a
random by user input. In cells A1 through to A32 I have a list o
items. I would like to place any of these items into a cell in colum
C when I strike a key into column B.
Example:
If my items were for arguments sake 32 different fruits, and any tim
by placing a 1 in cell b5 then the corrisponding fruit would appear i
cell c5. If apples were assigned 1, oranges 2, bananas 3, pears 4 an
so on. When I entered a 3 in cell b5, cell c5 would read...bananas an
if I entered a 2 in cell b6, cell c6 would then read oranges.
I can seem to do this funtion with IF but only to 8 items, does anyon
know how I can accomplish this with 32 items?
Thank you for your time
I am trying to use a list of 32 items that may be inserted in a cell a
random by user input. In cells A1 through to A32 I have a list o
items. I would like to place any of these items into a cell in colum
C when I strike a key into column B.
Example:
If my items were for arguments sake 32 different fruits, and any tim
by placing a 1 in cell b5 then the corrisponding fruit would appear i
cell c5. If apples were assigned 1, oranges 2, bananas 3, pears 4 an
so on. When I entered a 3 in cell b5, cell c5 would read...bananas an
if I entered a 2 in cell b6, cell c6 would then read oranges.
I can seem to do this funtion with IF but only to 8 items, does anyon
know how I can accomplish this with 32 items?
Thank you for your time