Okay, so I've finally got it.
I attached a spreadsheet for anyone interested
For my application, I was moving the center point of the sphere along an arc, and outputing its intersection with a circle that has a fixed center. I was only interested in 1 of the 2 intersection points.
If you are...