Move Column C to Column E. Then use the following equation and copy down:

=vlookup(B1,$D$1:$E$1000,2,false)