Home > database >  How to display data from another tab based on heading?
How to display data from another tab based on heading?

Time:12-20

I'm in a problem as per the question, i want to display the data on the basis of heading. Heading's position may subject to change from column A to C per week, so =InputA1 formula is not what i need.It have to match both tab headings and display under output tab ( under the matching heading ).

One more thing i need is input may contain huge data where i want to

avoid the row if stock less than 10
avoid the row if code is empty
avoid the row if UNC is 0 or blank

A sample sheet is dropped below where there is estimated output also. Please help me.

enter image description here

  • Related