formula

[cplrich]

I'm trying to come up with a formula and wondering if i can get some help?
If a1=1 then d1=15, a1=2 then d1=20, a1=3 them d1=30,a1=4 then d1=40

[#2 · Accepted solution]

@cplrich 

As variant in D1

=IFERROR(CHOOSE(A1,15,20,30,40), "wrong index")

[#3]

that worked thank you!

[#4]

@cplrich , my pleasure