Fill down a formula that refers to a cell in another column in Google Sheets- Part 1 before fill down

My name is Corey, I have been building spreadsheets for companies for over 7 years, I was a data specialist at an online school for 5 years, and I created this website to help people learn how to use spreadsheets.