if-else HELP!

Is there a quick and easy way to get

=IF($E$93=1,A3,IF($E$93=2,B3,IF($E$93=3,E3,IF($E$93=4,H3,IF($E$93=5,I3,IF($E$93=6,G3,IF($E$93=7,J3,IF($E$93=8,K3,IF($E$93=10,S3,IF($E$93=11,T3,""))))))))))

to work better?

I did this in the formula bar, but Im about to add more, and it's getting cumbersome, maybe some VBA?

if cell E93 = 1, then put contents of A3, if 2 then B3, if 3 then B3 etc.... the problem is that I might have E93 = 30 then xxx.... but its a pain in the behind to add all this code, there has to be a faster and and cleaner way to put all if-else, if-then statements.

FlameRetired got it working!

Originally Posted by FlameRetired

This is one way.

Formula:

Please Login or Register  to view this content.

thanks! this worked! how does it work? I see quotation marks, and my original code has value 9 missing, so how does it know what should follow?

Originally Posted by FlameRetired

CHOOSE needs something in the 9th position. Since there are no 9s to pass I put in a "blank" or null string as a placeholder. The last is what to return if there is an error ... ie no places for the number in E93 ... for example 13.

The best way to answer the rest of your question would be to look at the online help file (F1). Then search CHOOSE. It's actually a good explanation IMPO.

Thanks, I checked, but now my problem is
=IFERROR(CHOOSE($E$93,A3,B3,E3,H3,I3,G3,J3,K3,"",S3,T3),"")

to this:
=IFERROR(CHOOSE($E$93,A3:K3,"",S3,T3),"")

Can I do a range for the value?

Originally Posted by FDibbins

instead of everyone guessing, I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

FlameRetired got it working, I can't upload.
This works.
=IFERROR(CHOOSE($E$93,A3,B3,E3,H3,I3,G3,J3,K3,"",S3,T3),"")

But... I was wondering if I can shorten it by using ranges.
so it looks more like this.
=IFERROR(CHOOSE($E$93,A3:K3,"",S3,T3),"")