A001 instead of P41_A001_2G

Hi,

I have code numbers formatted in mess up way. ie. P41_A001_2G, P41_B23_2G,.....
i want to use if condition to return value base on the code number. However, i do not want to type the whole P41_A001_2G in my cell, and just want to use A001 or B23 instead.

=IF(C2=A3,"Yes","No")

How to trim a way P41_ and _2G and using only 3 characters in the middle as condition to return Yes or No?