Match up columns with name and number

[chughes49]

Hey Yall,

I attached a sample. I currently have two tables (the one on the left needs to stay the way it is). I am trying to match the right table with its corresponding value to the left table. Any help would be extremely appreciated thanks!

[#2]

In Column E, you may use a simple VLOOKUP, like this:
=VLOOKUP(D1,
A:B,
2,0)