Excel_Cell to show value of other cell when adjacent cell changes

Hi!   I need help with this! I assume the answer will be quite simple but I cannot come up with any idea:   I have the following values.  A1: Glass / B1: REF123 A2: Timber / B2: REF240 A3: Ste...