Hi, i am doing a project for school and i am in a bit of trouble with a situation i have.
i want various other cells to change, according to what is in one cell.
as you can see in my picture of my spreadsheet, i want the rows - D5,E5,F5 to change according to what job they do, i think it is a IF formula that can be used to achieve this.
thank you for your time