Spreadsheet: 60329d1260890073-match-and-return-value-sample-formulas-for-qtys-in-applied-parts
Sheet: Applied Parts

PART-NO | QTY\U+002E | APPLY-TO | [NAME] | Qty Apply To Ship | Qty Apply To Apply
AA85-100 | 4 | U10-101A | 0 | 0
AA85-100 | 4 | U10-101B | 0 | 0
AA85-100 | 4 | U10-101C | 0 | 0
AA85-100 | 4 | U10-102A | 0 | 0
AA85-100 | 4 | U10-102B | 0 | 0
AA85-100 | 4 | U10-102C | 0 | 0
AA85-100 | 4 | U11-101A | 0 | 0
AA85-100 | 4 | U11-101B | 0 | 0
AA85-100 | 4 | U11-101C | 0 | 0
AA85-100 | 4 | U11-102A | 0 | 0
AA85-100 | 4 | U11-102B | 0 | 0
AA85-100 | 4 | U11-102C | 0 | 0
AA85-100 | 4 | U11-103A | 0 | 0
AA85-100 | 4 | U11-103B | 0 | 0
AA85-100 | 4 | U11-103C | 0 | 0
AA85-100 | 4 | U11-104A | 0 | 0
AA85-100 | 4 | U11-104B | 0 | 0
AA85-100 | 4 | U11-104C | 0 | 0
AA85-100 | 2 | U12-101A | 0 | 0
AA85-100 | 4 | U12-101B | 0 | 0
AA85-100 | 4 | U12-101C | 0 | 0
AA85-100 | 4 | U12-102A | 0 | 0
AA85-100 | 4 | U12-102B | 0 | 0
AA85-100 | 2 | U12-103A | 0 | 0
AA85-100 | 4 | U12-103B | 0 | 0
AA85-100 | 4 | U12-103C | 0 | 0
AA85-100 | 4 | U12-103D | 0 | 0
AA85-100 | 4 | U12-104A | 0 | 0
AA85-100 | 4 | U12-104B | 0 | 0
AA85-100 | 4 | U12-104C | 0 | 0
AA85-100 | 1 | U12-105A | 0 | 0
AA85-100 | 2 | U12-105B | 0 | 0
AA85-100 | 2 | U12-105C | 0 | 0
AA85-100 | 4 | U12-106A | 0 | 0
AA85-100 | 4 | U12-106B | 0 | 0
AA85-100 | 4 | U12-107A | 0 | 0
AA85-100 | 2 | U12-107B | 0 | 0
AA85-100 | 2 | U12-107C | 0 | 0
AA85-100 | 2 | U12-108B | 0 | 0
AA85-100 | 2 | U12-108C | 0 | 0
AA85-100 | 4 | U12-108D | 0 | 0
AA85-100 | 4 | U12-109A | 0 | 0
AA85-100 | 4 | U12-109B | 0 | 0
AA85-100 | 4 | U12-110A | 0 | 0
AA85-100 | 2 | U12-110B | 0 | 0
AA85-100 | 2 | U12-110C | 0 | 0
AA85-100 | 2 | U12-111A | 0 | 0
AA85-100 | 2 | U12-111B | 0 | 0
AA85-100 | 2 | U12-112A | 0 | 0
AA85-100 | 2 | U12-112B | 0 | 0
AA85-100 | 2 | U13-101A | 0 | 0
AA85-100 | 4 | U13-101B | 0 | 0
AA85-100 | 4 | U13-101C | 0 | 0
AA85-100 | 4 | U8-101A | 0 | 0
AA85-100 | 4 | U8-101B | 0 | 0
AA85-100 | 4 | U8-101C | 0 | 0
AA85-100 | 2 | U8-103A | 0 | 0
AA85-100 | 2 | U8-103B | 0 | 0
AA85-100 | 4 | U8-103C | 0 | 0
AA85-100 | 4 | U8-104A | 0 | 0
AA85-100 | 4 | U8-104B | 0 | 0
AA85-100 | 4 | U8-104C | 0 | 0
AA85-100 | 4 | U8-105B | 0 | 0
AA85-100 | 2 | U8-105C | 0 | 0
AA85-100 | 4 | U8-106A | 0 | 0
AA85-100 | 4 | U8-106B | 0 | 0
AA85-100 | 4 | U8-106C | 0 | 0
AA85-100 | 4 | U8-106D | 0 | 0
AA85-100 | 1 | U8-107A | 0 | 0
AA85-100 | 2 | U8-107C | 0 | 0
AA85-100 | 4 | U8-108A | 0 | 0
AA85-100 | 2 | U8-109A | 0 | 0
AA85-100 | 4 | U8-109B | 0 | 0
AA85-100 | 4 | U8-109C | 0 | 0
AA85-100 | 2 | U8-110A | 0 | 0
AA85-100 | 4 | U8-110B | 0 | 0
AA85-100 | 4 | U8-110C | 0 | 0
AA85-100 | 4 | U9-101A | 0 | 0
AA85-100 | 4 | U9-101B | 0 | 0
AA85-100 | 4 | U9-101C | 0 | 0
AA85-100 | 4 | U9-102A | 0 | 0
AA85-100 | 4 | U9-102B | 0 | 0
AA85-100 | 4 | U9-102C | 0 | 0
AA85-100 | 2 | U9-103A | 0 | 0
AA85-100 | 2 | U9-103B | 0 | 0
AA85-100 | 4 | U9-104A | 0 | 0
AA85-100 | 4 | U9-104B | 0 | 0
AA85-100 | 4 | U9-104C | 0 | 0
AA85-100 | 2 | U9-105A | 0 | 0
AA85-100 | 2 | U9-105B | 0 | 0
AA85-100 | 4 | U9-105C | 0 | 0
AA85-100 | 4 | U9-105D | 0 | 0
AA85-100 | 2 | U9-106A | 0 | 0
AA85-100 | 2 | U9-106B | 0 | 0
AN-100 | 1 | U10-101A | 0 | 0
AN-100 | 1 | U10-102A | 0 | 0
AP-100 | 1 | U8-103A | 0 | 0
AP-100 | 1 | U8-103B | 0 | 0
AP-100 | 1 | U8-105A | 0 | 0
AP-100 | 2 | U8-105B | 0 | 0
AP-100 | 1 | U8-105C | 0 | 0
AP-100 | 1 | U8-107A | 0 | 0
AP-100 | 1 | U9-103A | 0 | 0
AP-100 | 1 | U9-103B | 0 | 0
AP-100 | 1 | U9-105A | 0 | 0
AP-100 | 1 | U9-105B | 0 | 0
AP-100 | 1 | U9-106A | 0 | 0
AP-100 | 1 | U9-106B | 0 | 0
AP-101 | 2 | CC-100 | 1 | 2
AP-101 | 2 | CC-101 | 1 | 2
AP-101 | 2 | CC-102 | 1 | 2
AP-101 | 2 | CC-103 | 1 | 2
AP-101 | 1 | CC-104 | 1 | 1
AP-102 | 2 | CC-100 | 1 | 2
AP-102 | 2 | CC-101 | 1 | 2
AP-102 | 2 | CC-102 | 1 | 2
AP-102 | 2 | CC-103 | 1 | 2
AP-102 | 1 | CC-104 | 1 | 1
AP-102 | 2 | CC-107 | 1 | 2
AP-102 | 2 | CC-108 | 1 | 2
AP-102 | 2 | CC-109 | 1 | 2
AP-102 | 2 | CC-110 | 1 | 2
AP-102 | 2 | CC-111 | 1 | 2
AP-102 | 2 | CC-112 | 1 | 2
AP-102 | 2 | CC-113 | 1 | 2
AP-102 | 2 | CC-114 | 1 | 2
AP-102 | 2 | CC-115 | 1 | 2
AP-102 | 1 | CC-119 | 1 | 1
AP-102 | 2 | CC-120 | 1 | 2
AP-102 | 2 | CC-121 | 1 | 2
AP-103 | 2 | CC-100 | 1 | 2
AP-103 | 2 | CC-101 | 1 | 2
AP-103 | 2 | CC-102 | 1 | 2
AP-103 | 2 | CC-103 | 1 | 2
AP-103 | 1 | CC-104 | 1 | 1
AP-103 | 2 | CC-107 | 1 | 2
AP-103 | 2 | CC-108 | 1 | 2
AP-103 | 2 | CC-109 | 1 | 2
AP-103 | 2 | CC-110 | 1 | 2
AP-104 | 1 | CC-104 | 1 | 1
AP-105 | 1 | CC-104 | 1 | 1
AP-106 | 1 | CC-104 | 1 | 1
AP-107 | 1 | U9-104A | 0 | 0
AP-108 | 1 | U9-104A | 0 | 0
AP-109 | 1 | U12-103C | 0 | 0
AP-109 | 1 | U12-106A | 0 | 0
AP-109 | 1 | U12-108C | 0 | 0
AP-109 | 1 | U12-108D | 0 | 0
AP-109 | 1 | U12-109A | 0 | 0
AP-109 | 1 | U12-112A | 0 | 0
AP-109 | 1 | U8-103C | 0 | 0
AP-109 | 1 | U8-104A | 0 | 0
AP-109 | 1 | U8-105C | 0 | 0
AP-109 | 1 | U8-106A | 0 | 0
AP-109 | 1 | U8-106B | 0 | 0
AP-109 | 1 | U8-108A | 0 | 0
AP-111 | 2 | CC-105 | 1 | 2
AP-111 | 2 | CC-106 | 1 | 2
AP-114 | 1 | U8-106A | 0 | 0
AP-115 | 1 | U8-106A | 0 | 0
AP-116 | 1 | U12-105A | 0 | 0
AP-116 | 1 | U12-105B | 0 | 0
AP-116 | 1 | U12-108A | 0 | 0
AP-116 | 1 | U12-108B | 0 | 0
AP-116 | 1 | U12-108C | 0 | 0
AP-116 | 1 | U12-111A | 0 | 0
AP-117 | 1 | U12-111B | 0 | 0
AP-117A | 1 | AP-117 | 0 | 0
AP-117B | 1 | AP-117 | 0 | 0
AP-118 | 1 | U12-110C | 0 | 0
AP-118 | 1 | U12-112B | 0 | 0
AP-123 | 1 | BR-156 | 2 | 2
AP-124 | 2 | CC-105 | 1 | 2
AP-124 | 2 | CC-106 | 1 | 2
AP-125 | 2 | CC-107 | 1 | 2
AP-125 | 2 | CC-108 | 1 | 2
AP-125 | 2 | CC-109 | 1 | 2
AP-125 | 2 | CC-110 | 1 | 2
AP-126 | 2 | CC-111 | 1 | 2
AP-126 | 2 | CC-112 | 1 | 2
AP-126 | 2 | CC-113 | 1 | 2
AP-126 | 2 | CC-114 | 1 | 2
AP-126 | 2 | CC-115 | 1 | 2
AP-126 | 1 | CC-119A | 0 | 0
AP-126 | 1 | CC-122B | 0 | 0
AP-127 | 2 | CC-111 | 1 | 2
AP-127 | 2 | CC-112 | 1 | 2
AP-127 | 2 | CC-113 | 1 | 2
AP-127 | 2 | CC-114 | 1 | 2
AP-127 | 2 | CC-115 | 1 | 2
AP-128 | 1 | CC-116 | 1 | 1
AP-128 | 1 | CC-119 | 1 | 1
AP-129 | 1 | CC-116 | 1 | 1
AP-129 | 2 | CC-117 | 1 | 2
AP-129 | 1 | CC-118 | 1 | 1
AP-130 | 1 | CC-116 | 1 | 1
AP-130 | 2 | CC-117 | 1 | 2
AP-130 | 1 | CC-118 | 1 | 1
AP-131 | 1 | CC-116A | 0 | 0
AP-132 | 1 | CC-118A | 0 | 0
AP-133 | 1 | CC-116A | 0 | 0
AP-134 | 1 | CC-118A | 0 | 0
AP-135 | 1 | CC-119 | 1 | 1
AP-135 | 2 | CC-120 | 1 | 2
AP-135 | 2 | CC-121 | 1 | 2
AP-136 | 1 | CC-119 | 1 | 1
AP-136 | 2 | CC-120 | 1 | 2
AP-136 | 2 | CC-121 | 1 | 2
AP-137 | 1 | CC-119A | 0 | 0
AP-137 | 1 | CC-122B | 0 | 0
AP-138 | 1 | CC-119A | 0 | 0
AP-139 | 1 | CC-122B | 0 | 0
AP-140 | 1 | CC-122C | 0 | 0
BR-160 | 1 | U12-102A | 0 | 0
BR-161 | 1 | U12-104A | 0 | 0
CC-116A | 1 | CC-116 | 1 | 1
CC-118A | 1 | CC-118 | 1 | 1
CC-119A | 1 | CC-119 | 1 | 1
CC-122A | 1 | CC-122 | 1 | 1
CC-122B | 1 | CC-122 | 1 | 1
CC-122C | 1 | CC-122 | 1 | 1
T739-100 | 2 | CC-100 | 1 | 2
T739-100 | 2 | CC-101 | 1 | 2
T739-100 | 1 | CC-110 | 1 | 1
T739-100 | 2 | CC-112 | 1 | 2
T739-100 | 2 | CC-113 | 1 | 2
T739-101 | 1 | CC-107 | 1 | 1
T739-102 | 2 | CC-102 | 1 | 2
T739-102 | 2 | CC-114 | 1 | 2
T739-103 | 2 | CC-103 | 1 | 2
T739-103 | 2 | CC-115 | 1 | 2
T739-104 | 1 | CC-104 | 1 | 1
T739-105 | 1 | CC-104 | 1 | 1
T739-106 | 1 | CC-105 | 1 | 1
T739-107 | 1 | CC-105 | 1 | 1
T739-108 | 1 | CC-106 | 1 | 1
T739-109 | 1 | CC-106 | 1 | 1
T739-110 | 1 | CC-107 | 1 | 1
T739-110 | 1 | CC-111 | 1 | 1
T739-111 | 2 | CC-108 | 1 | 2
T739-111 | 2 | CC-109 | 1 | 2
T739-111 | 1 | CC-111 | 1 | 1
T739-112 | 1 | CC-110 | 1 | 1
T739-113 | 1 | CC-116 | 1 | 1
T739-114 | 1 | U8-109C | 0 | 0
T739-115 | 1 | U8-110C | 0 | 0
T739-116 | 1 | CC-116 | 1 | 1
T739-117 | 1 | CC-116 | 1 | 1
T739-118 | 1 | CC-117 | 1 | 1
T739-119 | 1 | CC-117 | 1 | 1
T739-120 | 1 | CC-117 | 1 | 1
T739-121 | 1 | CC-118 | 1 | 1
T739-122 | 1 | CC-118 | 1 | 1
T739-123 | 1 | CC-118 | 1 | 1
T739-124 | 1 | CC-119 | 1 | 1
T739-125 | 1 | CC-120 | 1 | 1
T739-126 | 1 | CC-121 | 1 | 1
T739-127 | 1 | U13-101C | 0 | 0
U10-101A | 1 | U10-101 | 1 | 1
U10-101B | 2 | U10-101 | 1 | 2
U10-101C | 1 | U10-101 | 1 | 1
U10-102A | 1 | U10-102 | 1 | 1
U10-102B | 2 | U10-102 | 1 | 2
U10-102C | 1 | U10-102 | 1 | 1
U11-101A | 1 | U11-101 | 1 | 1
U11-101B | 4 | U11-101 | 1 | 4
U11-101C | 1 | U11-101 | 1 | 1
U11-102A | 1 | U11-102 | 1 | 1
U11-102B | 4 | U11-102 | 1 | 4
U11-102C | 1 | U11-102 | 1 | 1
U11-103A | 1 | U11-103 | 1 | 1
U11-103B | 4 | U11-103 | 1 | 4
U11-103B | 5 | U12-106 | 1 | 5
U11-103B | 8 | U8-108 | 1 | 8
U11-103C | 1 | U11-103 | 1 | 1
U11-103C | 1 | U8-108 | 1 | 1
U11-104A | 1 | U11-104 | 1 | 1
U11-104B | 4 | U11-104 | 1 | 4
U11-104C | 1 | U11-104 | 1 | 1
U12-101A | 1 | U12-101 | 1 | 1
U12-101B | 4 | U12-101 | 1 | 4
U12-101C | 1 | U12-101 | 1 | 1
U12-102A | 1 | U12-102 | 1 | 1
U12-102B | 1 | U12-102 | 1 | 1
U12-103A | 1 | U12-103 | 1 | 1
U12-103B | 3 | U12-103 | 1 | 3
U12-103C | 1 | U12-103 | 1 | 1
U12-103D | 1 | U12-103 | 1 | 1
U12-104A | 1 | U12-104 | 1 | 1
U12-104B | 1 | U12-104 | 1 | 1
U12-104C | 1 | U12-104 | 1 | 1
U12-105A | 1 | U12-105 | 1 | 1
U12-105B | 1 | U12-105 | 1 | 1
U12-105C | 1 | U12-105 | 1 | 1
U12-106A | 1 | U12-106 | 1 | 1
U12-106B | 1 | U12-106 | 1 | 1
U12-107A | 1 | U12-107 | 1 | 1
U12-107B | 1 | U12-107 | 1 | 1
U12-107C | 1 | U12-107 | 1 | 1
U12-108A | 1 | U12-108 | 1 | 1
U12-108B | 1 | U12-108 | 1 | 1
U12-108C | 1 | U12-108 | 1 | 1
U12-108D | 1 | U12-108 | 1 | 1
U12-109A | 1 | U12-109 | 1 | 1
U12-109B | 1 | U12-109 | 1 | 1
U12-110A | 1 | U12-110 | 1 | 1
U12-110B | 1 | U12-110 | 1 | 1
U12-110C | 1 | U12-110 | 1 | 1
U12-111A | 1 | U12-111 | 1 | 1
U12-111B | 1 | U12-111 | 1 | 1
U12-112A | 1 | U12-112 | 1 | 1
U12-112B | 1 | U12-112 | 1 | 1
U13-101A | 1 | U13-101 | 2 | 2
U13-101B | 7 | U13-101 | 2 | 14
U13-101C | 1 | U13-101 | 2 | 2
U8-101A | 1 | U8-101 | 1 | 1
U8-101B | 4 | U8-101 | 1 | 4
U8-101C | 1 | U8-101 | 1 | 1
U8-103A | 1 | U8-103 | 1 | 1
U8-103B | 1 | U8-103 | 1 | 1
U8-103C | 1 | U8-103 | 1 | 1
U8-104A | 1 | U8-104 | 1 | 1
U8-104B | 3 | U8-104 | 1 | 3
U8-104C | 1 | U8-104 | 1 | 1
U8-105A | 1 | U8-105 | 1 | 1
U8-105B | 1 | U8-105 | 1 | 1
U8-105C | 1 | U8-105 | 1 | 1
U8-106A | 1 | U8-106 | 1 | 1
U8-106B | 1 | U8-106 | 1 | 1
U8-106C | 5 | U8-106 | 1 | 5
U8-106D | 1 | U8-106 | 1 | 1
U8-107A | 1 | U8-107 | 1 | 1
U8-107B | 1 | U8-107 | 1 | 1
U8-107C | 1 | U8-107 | 1 | 1
U8-108A | 1 | U8-108 | 1 | 1
U8-109A | 1 | U8-109 | 1 | 1
U8-109B | 7 | U8-109 | 1 | 7
U8-109C | 1 | U8-109 | 1 | 1
U8-110A | 1 | U8-110 | 1 | 1
U8-110B | 1 | U12-102 | 1 | 1
U8-110B | 7 | U8-110 | 1 | 7
U8-110C | 1 | U8-110 | 1 | 1
U9-101A | 1 | U9-101 | 1 | 1
U9-101B | 4 | U9-101 | 1 | 4
U9-101C | 1 | U9-101 | 1 | 1
U9-102A | 1 | U8-102 | 1 | 1
U9-102A | 1 | U9-102 | 1 | 1
U9-102B | 4 | U8-102 | 1 | 4
U9-102B | 4 | U9-102 | 1 | 4
U9-102C | 1 | U8-102 | 1 | 1
U9-102C | 1 | U9-102 | 1 | 1
U9-103A | 1 | U9-103 | 1 | 1
U9-103B | 1 | U9-103 | 1 | 1
U9-104A | 1 | U9-104 | 1 | 1
U9-104B | 2 | U9-104 | 1 | 2
U9-104C | 1 | U9-104 | 1 | 1
U9-105A | 1 | U9-105 | 1 | 1
U9-105B | 1 | U9-105 | 1 | 1
U9-105C | 1 | U9-105 | 1 | 1
U9-105D | 1 | U9-105 | 1 | 1
U9-106A | 1 | U9-106 | 1 | 1
U9-106B | 1 | U9-106 | 1 | 1