Allow List Validation II

Update the output cells so that each row shows "Yes" only when both conditions are true: (1) the SKU in column B does not appear anywhere in the list in G3:G6, and (2) the text in column D does not contain the uppercase word HOLD. If either condition fails, show "No". See Examples

Your solution should use cell references so it updates automatically if the input cells change values.

A1
fx

This cell cannot be edited

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50