hello
dummy workbooks are great help in solving certain problems.

Is this what you are expecting?

=lookup(B1,C$1:C$45,D$1:D$45)