Check to see if a value exists on another tab

[gheyman]

I have a list of parts, I want to add a formula next to each to see if they exist on another tab. I now I can create a nested Iserror formula inside an If statement =IF((ISERROR(INDEX(IMD_BOM!F:F,MATCH([Top Assembly],IMD_BOM!A:AS,0))))=TRUE,"NO","YES")

But is there a better more efficient way?

 

[Fluff]

No need for the index, you can do it like
=IF(ISNUMBER(MATCH(A1,IMD_BOM!A:A,0)),"YES","NO")