I need one cell to reference different cells based on another call's value

I hope I explain this correctly.

I am looking for a formula that allows one call to reference a specific call based on the value of another cell.

For instance If cell A1=10 (I manually put in this value), Cell B2=C3 If Cell A1=12 Cell B2=C4 If Cell A1=14 Cell B2=C5 If Cell A1=16 Cell B2=C6 And so on.

I was able to accomplish the first instance If Cell A1=10 Cell B2=C3 using the IF command

=IF(A1=10,C3)

But if any other number is in Cell A1 it just displays False. How can I get it to reference different cells based on the value of A1?

Thank you,

Recent Questions...