The formula in B1 would be VLOOKUP(A1, etc). Since you're going to
copy this down a column, here's a tip: when you define the look-up
range in the VLOOKUP use reference anchors (for instance, $D$1:$E$10)
to lock the range.