1. Use a VLOOKUP formula to automatically get the calculated return on investment for each genre, director, and actors.
  2. Enter the search key, range, index, and sort status
  3. Check the average ROI in the spreadsheet.
  4. Copy the formula
  5. Change the ranges
  6. Check the formulas.