Hello folks,
I need some help getting data from a graph to display its value in a given cell. I've attached the file for reference. (using sheet titled Loading (172P)
I have a graph with multiple lines (series) depicting certain items, (.i.e, fuel, rear pax, etc.). For example, in Cell D5, I input a number and when I look to the graph, I find 190 in terms of weight, go across that line until I intersect with the Pilot & Front Pax line, then go down to see what number I need to input into Cell E5.
What I would like to do is, when I input a value, say in Cell D10, I want/need a formula that looks for that number on the graph until it intersects with the fuel line, then input that value in Cell E10. Is that even possible??
Bookmarks