# an if? question

#### darvis

##### New Member
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

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

##### MrExcel MVP
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

##### New Member
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

##### Well-known Member
Still, you can do the trick with (V)LOOKUP.
Or do you mean BB1 looks like this:
Code:
``One, Two, Three, Four, Five``
everything in one cell?

#### darvis

##### New Member
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 : )

Replies
8
Views
829
Replies
0
Views
191
Replies
3
Views
147
Replies
0
Views
250
Replies
3
Views
5K

1,191,191
Messages
5,985,204
Members
439,947
Latest member
fabiannic

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back