IFERROR, MATCH, INDEX functions to find differences of two sheets

thank for pointing this out. I might need to check my spreadsheets now.

But in this case, because the file D123-MMD-C4-EFA-C101_6-00001 is on the list of BC, but rev P22 and not rev C04,
I want to not only see 'Not Found' (what I have now), but also what revision BC has - in this case P22.

And if it is not on the list, then show 'Not Found'. If possible.. Is it possible?.. )

But you might be right about & signs, I am a beginner with those :D