I have used filter formula because i was doing it on google sheet. =TRANSPOSE(FILTER(F5:H34,C5:C34=L6,D5:D34=L7))