Try,
1] All Criteria Table header D3:N3, must as same as the Source Table header "Dynamic "sheet A1:Y1
2] I revised "FNO" sheet F4 &L4, from "VOL" to "Volume" for demonstration purpose.
3] Then,
In D5 copied across right to H5 and all down:
=IFERROR(OFFSET(Dynamic!$B$1,MATCH($I5,0+RIGHT(Dynamic!$B$1:$B$50,5),0)-(LOOKUP("zz",$D$3:D$3)="PUT"),MATCH(D$4,Dynamic!$A$1:$Y$1,0)-2),"")
And
4] copy and paste formulae from D5:H25 to J5:N25
View attachment 83187
Which, IMO, we should not be obliged to open to see your requirementsI have already described what I needed in attached sample file intself.