IT EDUCATION

The formula in Cell C4 is =VLOOKUP(A4,$E$4:$G$8,3,FALSE)*B4.  Double click in Cells C4, C5, and C6 to see the formulas.

If you copy this formula down, note that A4 and B4 will change to A5 and B5, then A6 and B6, and so on down the column.