We're trying to set a associative hardware token on our pulls and are running into an issue.

What we're trying to do is have all pulls that are on drawers be counterbored on the back side so that the screw head is below the face so the pulls can be attached before the drawer front is added. We're using the Foundation library, so the rub is when the Finished Face subassembly is nested in a component insert your LookUpTable is in N! not S!. Here's what I've tried:

=IF(IFERROR(VLOOKUP(S!Bay_Position,S!LookupTableBayPositions,8,FALSE),IFERROR(VLOOKUP(N!Bay_Position,N!LookupTableBayPositions,8,FALSE),0))="D","BORE",0)&"[COUNTERSINK]"

The problem is that if it's not a nested sub, and there's no N!, it doesn't error out like I'd hoped, it becomes an invalid formula and breaks the token all together. I assumed with the first IFERROR, that if the S! lookup returned a value, it would ignore the second half with N! and not try to evaluate it at all, but it does, and it breaks.

If I just hard code a BORE, it works fine, just on all finished faces, and not the drawer fronts alone. We were doing this off whether or not there were cam adjusters in the component library, but they've been moved to the sub fronts in foundation.

Anyone have any ideas? Different approach that actually works?