Question: how do you copy and paste a vlookup formula?
Answer: Select cell C3 and click on it.
Insert the formula: =VLOOKUP(B3,$E$3:$F$7,2,0)
Press enter.
Drag the formula down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.