formula for populaing other cells
 

can you help please. ihave a formula that is checking for a specific number
and when the number is shown a value is entered into the cell, but ineed to
also show that value in another cell without entering a formula in the other
cell eg (= b5) where b5 is the cell with the value in.

please any advice