If question involving 3 variables

[jlo33]

I have a question regarding the IF formula.

What I am needing to do is this:

If B21 equals any cell between A1:A12 enter what is found in E1
If B21 equals A13 enter what is found in E3
If B21 equals A14 enter what is found in E5

I hope this is clear what I am needing.

Thanks!

[Jonmo1]

Try

=IF(COUNTIF(A1:A12,B21),E1,IF(B21=A13,E3,IF(B21=A14,E5,"")))

[Ace_XL]

Try

=IF(COUNTIF(A1:A12,B21),E1,IF(A13=B21,E3,IF(A14=B21,E5,"")))