I am trying to find a formula/Function that will help me do the following.

Table.
Column A: List of Names
Column B: Numerical Values

Column C: List of Names
Column D: Empty

A function that will fill in Column D with a Numerical Value found in Column
B where Column A = Column B.

Example Data.
Column A
Row 1 Jimmy
Row 2 Steve

Column B
Row 1 '4'
Row 2 '8'

Column C
Row 1 Steve
Row 2 Jimmy

Column D
Row 1 Empty
Row 2 Empty

After putting in this formula Column D should look like
Row 1 '8'
Row 2 '4'

Thanks