I believe Professional Plus 2021 has the TOCOL function, if so, you could also use:
=TOCOL(IF('Raw data'!$A$2:$E$6=A5,'Raw data'!$F$2:$F$6,NA),2)