Skip Row If Conditions Not Met

[V.BALJEKAR]

I work with an excel 2013.

As the heading says I need a formula to return those details which meet the given two conditions.
In other words, it should skip to next row if any of the two conditions are not met.
The detail I am looking for is in the column "Item details"

The sample excel file is attached.

Requesting for a solution for the same.

 

[AliGW]

In K5:

=IFERROR(INDEX(C:C,SMALL(IF(($B$5:$B$600="IH")*($H$5:$H$600>0),ROW($B$5:$B$600)),ROWS($1:1))),"")

Confirm using CTRL+SHIFT+ENTER (not just ENTER) and then copy down.

 

[V.BALJEKAR]

I will try it out and confirm its working. Thank you.

 

[AliGW]

It is working in the sample workbook - did you look at the attachment?

 

[V.BALJEKAR]

Yes. I had looked at the attachment and its giving the correct results in my working file too.
Thank you so much for the prompt response and the solution.

 

[AliGW]

You're welcome. Feel free to LIKE my solution.