VLOOKUP and return specific text from multiple choices

so three days now working on this, hope someone can help

sheet1 has 6 columns

1 Part number / Name / code a / code b / code c / code d
2 12345 / apple / yes / no / yes / yes
3 75647 / Orange / no / no / no / yes
4 09000 / Banana / yes / yes / yes / yes

sheet2 has 3 columns

1 part number / name / code
2 12345 / apple / b
3 12345 / apple / a
4 12345 / apple / c
5 09000 / Banana / c
6 09000 / Banana / d

I want to show on sheet1 if part number 12345 matches sheet2 part number 12345 & has a code a in column C

=IFERROR(VLOOKUP([part number],'Sheet2'!,3,FALSE),"")

except i only want it to show if there is a code A in that column for that part number

THANKS!!!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.