So far, so good. But we need to look up the values for all of the cells in column D, not just the first cell.

We can easily copy this formula to all of the other cells in the column by dragging the small square handle at the lower right of the box around the selected cell.