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.

lookup.png

Regards