an if? question

[darvis]

first off hi all.... can someone tell me how to do the following?

if a1=1 then c1=dog (with c1 being the cell that the formula is housed in). but with multiple possible entries. in other words, a1 could equal 1-100, and each entry would result a diffrent answer in c1. i hop that makes sense

-- darvis

 

[Aladin Akyurek]

Have a look at look up functions like LOOKUP, VLOOKUP, etc.

Maybe just...

=INDEX(List, A1)

where A1 = 1,2,3,...,100 and List is a range that enumerates Dog,Cat,Lion,...

first off hi all.... can someone tell me how to do the following?

if a1=1 then c1=dog (with c1 being the cell that the formula is housed in). but with multiple possible entries. in other words, a1 could equal 1-100, and each entry would result a diffrent answer in c1. i hop that makes sense

-- darvis

 

[darvis]

hmmm i think i explained my question wrong.. my bad....... this is what i want to happen. in cell aa1 i would like a predetermined response based on what is entered in bb1, with there being a number of possibilities entered in bb1..... would it also be possible to have the answer given in aa1 to be determined not only by whats in bb1, but whats in bb1 compeared to whats in zz1. thanks for the help....

 

[dafan]

Still, you can do the trick with (V)LOOKUP.
Or do you mean BB1 looks like this:

One, Two, Three, Four, Five

everything in one cell?

 

[darvis]

first...thanks for the late night help... second i got the first part to work.. thanks again..... when im ready to try the multiple dependent response im sure ill ask for more help : )