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.