Excel Formula Solution need for plotting 1D Results from 2D list of data

I am not sure this can be done and I have pretty much given up think it is possible. However, I thought I would throw this query out to anyone listening/reading who may know a novel way of doing this. The idea is to avoid macros because this is the only thing that has limited me through formulation with Excel Environment.


I have attached a copy of the problem with some information on what the expect process is for deciding what to output. If it is not clear then I am happy to provide additional information to help.
I thought this could be solved using the indirect & lookup Excel methods.....but I am no advanced expert but feel I am close to getting it ( without macros )

cheers, Lee