Auto ISO allows you to set a maximum ISO that you're comfortable shooting at—in effect setting a “ceiling” for ISO, so if the light is constantly changing while you're shooting, the camera can automatically adjust ISO as necessary without going over the “ceiling” you set.