Perhaps enter in E2
=IF(INDEX($D2:$D100,MATCH($a2,$c2:$C100,0))=$b2,"" ,"error")
Adapt range as needed and pull down as needed ( or double-click the handle)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post