How to find the corresponding value in the table?

The first one worked, but I tried to replicate it to the others and give the error.

CodePudding user response：

This formula in E2 (then dragged down to E3, E4 and E5) should give you what you want:

=INDEX(A2:C2,MATCH(D2,$A$1:$C$1,0))

That should give you this:

Is that what you were after?