last stock quote how much and store number

Expected results plugged on x and y

The file looks as follows

Cancelled by Jt

Criteria logic is one cell out of 22 needs to be greater than 0 , the rest 0 , to pull that stock quantity
and then next cell to look for what stores number is that using the header

in x

=IF(COUNTIF(B3:W3,"<>0")=1,INDEX($B$1:$W$1,,SUMPRODUCT((B3:W3<>0)*--(COLUMN($B$1:$W$1)))-1),"")

in y

=IFERROR(INDEX(B3:W3,X3),"")

Works , the formula in Y not works
X is working

Works for me: it simply uses X value as index to store value.