Find the 2nd value based on more criteria

[Villalobos]

Hello,

I would need your help to find the 2nd value based on two criterias (Storage and Order number). Please, find attached my sample file with the desired result (cell M9).

Thank you in advance the help!

 

[Chihiro]

Something like...
Ind L9 and copy across to M9
=INDEX($D$9:$D$14,SMALL(IF(($H$9:$H$14=$U9)*($B$9:$B$14=$T9),ROW($D$9:$D$14)-ROW(D9)+1),COLUMN(A$1)))

Entered as array (CSE).

U9 = storage = 302

See attached.

 

[Villalobos]

Thank you very much!