as suggested, either vlookup or index/match...

=VLOOKUP(A21,$C$8:$F$13,2,FALSE)
=INDEX($C$7:$F$13,MATCH($A21,$C$7:$C$13,0),MATCH(D$20,$C$7:$F$7,0))
either will do what you want, adjust ranges as needed

edit: based on your last post, try this...
=VLOOKUP(A21,$C$8:$F$13,2,FALSE)&" "&VLOOKUP(A21,$C$8:$F$13,3,FALSE)&" "&VLOOKUP(A21,$C$8:$F$13,4,FALSE)

you can do the same concatenation with the index/match