The formula in google sheets

you Need to create a formula that will substitute data from one cell to other cells depending on what is specified in the cell.
Here is the table in which you can see the job