Creating index formula to find the Min value and heading with parameters

My question is in the sheet I have provided I have relevant destination from point"A" to point "B" to meet the parameter (Weight) to match the job(Mode type) and the relevant cost (Min cost) and will need to find the heading (The Min Value supplier) that the value was found under. I tried the Index, Match, IF formulas to find a solution however it is too complicating since there is too many variables involved. If there is other ways doing this problem please advice. I have attached a sample file.