(

CodePudding user response：

This can be dynamic using VLOOKUP() with MATCH()

=VLOOKUP($G2,$A$2:$D$17,MATCH(H$1,$A$1:$D$1,0),0)

enter image description here

This can be dynamic using XLOOKUP() with FILTER()

=XLOOKUP($G2,$A$2:$A$17,FILTER($B$2:$D$17,H$1=$B$1:$D$1))

enter image description here

enter image description here