Problem with If Statement & Multiple Variables

I have in cell c40 a data validation list with source equal Royal (=Royal) has been created.

Royal is a namebox that has a defined list of 7 options (6 actual options plus one that says "select via drop down") :

FA4 = Select via Drop Down
FA5 = option 1
FA6 = option 2
FA7 = option 3
FA8 = option 4
FA9 = option 5
FA10 = option 6

I have subsequently defined that each cell from FA5 to 10 is named
FA5 = SSR
FA6 = TSR
FA7 = THRSR
FA8 = SADA
FA9 = ADA2
FA10 = TENSR

I have also defined values in cells FB5 to 10 the following
FB4 = no value, blank,
FB5 = $10
FB6 = $20
FB7 = $30
FB8 = $40
FB9 = $50


The concept is that FA5 is associated with a value defined in FB5, FA6 is associated with FB6, so on

What I want to happen is when I select a value via the drop down selection in C40 eg. "Option 1" that in cell D40 the value associated with Option 1 (found in FA5) returns the value found in FB5 ($10).

How do I do this? I have tried a number of "if" statements but no luck.

Regards,

Piet

Have you tried Vlookup()

E.g.

=Vlookup(C40,$FA$5:$FB$9,2,FALSE)