Bit of fun - Formula Challenge - Lookup by column and row to return Headers

Bit of fun

what is the formula or formulas to lookup by each row in a column and to find a value and return the headers?

[Blocked Image: http://www.ozgrid.com/forum/attachment.php?attachmentid=70690&d=1479520689]

[ATTACH=CONFIG]70690[/ATTACH]

Re: Bit of fun - Formula Challenge - Lookup by column and row to return Headers

one solution

Re: Bit of fun - Formula Challenge - Lookup by column and row to return Headers

a practical example may help.
As the ground stay is moved away from a pole tip load (Cell C9) the diameter of the pole must increase to resist the applied load.
The algorithm calculates for the ground stay attachment position the diameter of pole required.
the puzzle in the pole selection table is to search by each column row value to find the minimum pole size with a Dia that satisfies the requirement then return the headers of the result.