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: Steel / B3: REF567

I want to find a formula so Excell shows automatically in cells B9 the following:

- B1 if B8 = A1

- B2 if B8 = A2

- B3 if B8 = A3.  

Also, the idea es that it works with ranges and when I modify B1, B2 and B3 the values in B9 change automatically!

Thank you very much for your help!

Paula