Hi All,
Need anyone helps. What's wrong with the below formula?
I want to use this formula
=IFERROR(INDEX(STORAGE_DATA!$E$3:$E$200,SMALL(IF(1=((--(INV_A6082!$I$1=STORAGE_DATA!$D$3:$D$200))*(--(INV_A6082!$K$1=STORAGE_DATA!$G$3:$G$200))),ROW(STORAGE_DATA!$E$3:$E$200)-4,""),ROW()-4)),"")
To list down data based on multiple criteria from the below 'STORAGE_DATA' sheet
To 'INV_A6082' sheet
Need anyone helps. What's wrong with the below formula?
I want to use this formula
=IFERROR(INDEX(STORAGE_DATA!$E$3:$E$200,SMALL(IF(1=((--(INV_A6082!$I$1=STORAGE_DATA!$D$3:$D$200))*(--(INV_A6082!$K$1=STORAGE_DATA!$G$3:$G$200))),ROW(STORAGE_DATA!$E$3:$E$200)-4,""),ROW()-4)),"")
To list down data based on multiple criteria from the below 'STORAGE_DATA' sheet
To 'INV_A6082' sheet