Custom function to find Heading & Subheading

[Meesam]

Hello everybody,
I am having a situation where I have heading of certain names or items and it is spread across 3-5 cells (merged as one) and underneath these cells there is subheading (each item occupying single independent cell). I just want a custom function that can LOOKUP the heading and then give me values corresponding to subheading of choice. I have attached relevant image for understanding. For example if in any other sheet or in the same sheet i want to lookup something FIRST by "Quantity" (main heading) and SECOND by subheading then how can i do the same?
Any guidance is much appreciated.

Image is below:

Best Regards

 

[Meesam]

Guys I have done some homework but this is just opposite of what i need. Basically I have related different tables using INDEX function. Using INDEX i can retrieve any information from any table. Example is given in following image.

Now I need to know the opposite. For example if I know the value "107" then HOW can I know that it belong to WHICH table i.e. A, B or C ?