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