Hi guys,

Basically i have a set of data plotted on an x-y scatter plot where at a single point the two curves cross over each other and meet at a single point, i.e. 'x and y values are both the same where they cross.

Im trying to determine this operating point by generating lookup tables for both each curve.,

for example in the x axis i need to match the same x value for one curve '1st lookup table row' with the same x value of the other curve '2nd lookup table row'. But the corresponding y values also need to be matching or relatively close to find the right point. Any ideas how this can be achieved, i was thinking of using a VLOOKUP and INDEX functions but it's much more complicated than that.

Any advice would be great,