Check out the TREND function in XL help. For your case, swap the known x's
and known y's (as XL doesn't really care which is which, its just by
definition programmed to "input x, find y")
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Deane" wrote:

I have drawn a number of (x,y) charts and i was wondering if there is a way
of locating an unknown x coordinate with a known y coordinate directly
without having to manually interpolate the data.