IF Statement is too long

[swhitesides]

Hello everyone... I am in much need of help if anyone knows how I can make this work...

Here is my situation:

I have a drop-down list of 20 values, depending upon which value is chosen a different formula will need to be performed.

Ex: Drop down list is Dog,Cat,Mouse,Bird,...,Horse
Cat is chosen, then cell returns in B3*C3
Mouse is chosen, then cell returns B4*C4
...it will have 20 different 'if,then' statements pretty much

I hope that makes sense.

I tried an IF statement, but it came out WAY too long, although an IF statement seems to be the only thing to come out with the correct result. Any help would be GREATLY APPRECIATED!!

Thanks in advance!!

 

[barry houdini]

Hello swhitesides, welcome to MrExcel

You can use a formula like

=CHOOSE(MATCH(A1,list,0),calc1,calc2......,calc20)

where A1 contains the dropdown, list is the list of 20 items and calcs are your B3*C3 etc.

If your B3*C3 etc. progresses one row at a time like your example then you can probably use a shorter formula like

=INDEX(B3:B22,MATCH(A1,list,0))*INDEX(C3:C22,MATCH(A1,list,0))