Hi guys, I am currently using the below formula that returns certain data
from a report ( multiple rows and columns ) and it's based on a product name.
What I would like to do is have the formula return data based on two things,
product name and product type but not sure it can be done with INDEX and
MATCH .... the data is returned based on B4 ( product name in that cell ) in
the below example ,,,, Commodities is my sheet tab name, I would like to have
the data returned based on B4 and D4 ( product name and product type ).

=IF(ISERROR(SMALL(Commodities!$L:$L,ROWS($B$4:B4)) ),"",
INDEX(Commodities!N:N,MATCH(SMALL(Commodities!$L:$ L,
ROWS($B$4:B4)),Commodities!$L:$L,0)))