This is a plain EXCEL question, no VBA solutions please!

I want to say, if cell1 value= cell 2 value, then set a certain cell equal
to cell2Avlaue
If not, then if it's equal to cell 3 value, then set this certain cell equal
to cell3Avlaue,
etc.

Since the cell I'm testing is always the same cell, is there a way to do
this without a big multi-nested if statement?

I'm afraid that the # of characters will be too long, since there are many
possibilities. Also, it seems embarrassingly inelegant to my user, even if
not. In case it matters, each value is distinct, so it can only equal one
or the other.

I think I could do this with lookup functions somehow, but don't like that
complexity either, as there will be thousands of them since I will repeat
this equation many times.

Thanks!
Dean