Short but useless answer -- yes this is achievable.

Can you clarify some things -- the blue line looks like it is simply interpolating between points of that series, is that correct? Will the red line always be a vertical line?

If I have interpreted correctly, and I assume that the red line will always be vertical and the intersection point will always be between the 5th and 6th data point, then I would use a simple TREND() function: =TREND($E$7:$E$8,$D$7:$D$8,$B$22)

If I cannot be sure that the intersection point will always be between the 5th and 6th point, but could be between any two points, (still assuming red line is always vertical), then I would use a linear interpolation algorithm (mostly a lookup problem) to find the segment that contains the intersection point, then find the y value and red's x value from the slope and intercept for that point. A couple of examples of how I might implement an interpolation algorithm:
https://www.excelforum.com/excel-for...ml#post4873049
https://www.excelforum.com/excel-cha...ml#post3904113

If I cannot assume that the red line will be vertical, then I would perform an interpolation based on both curves, then use solver/goal seek to find the point where interpolation_blue-interpolation_red=0. I'm assuming that there will only be one intersection point for red and blue. If/when it is possible for there to be multiple intersection points, I have to be more careful to be sure it converges on the desired intersection.

Does that help? What questions do you have in implementing any of these? Have I misunderstood anything?