Find a number in a column then assign another cell number for the output number

Hi,
I am new to Excel and formulas.

I need to find a number (lets say #1) in a column of 10 numbers and when found assign a different cell's number as the output.

How? And what formula do I use to accomplish this?

Thank You