### Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmstraighttovideo503 and ElibreBelgium at YouTube provide different Formulas For:Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest ValueSee how to:1. Type the starting number position for a list, such as 3, and have the formula show the records starting at 3, then going to the end, and once it hits the end, it starts at the top again. A rotating List with INDEX, MOD amd ROWS Functions.2. See how to Do a lookup that finds the smallest value that is greater than or equal to lookup_value using the INDEX, MATCH and COUNTIFS functions when the table must be sorted in ascending order (smallest to biggest)

Length:
08:52