Promo Eligibility Check

Update the output cells in so each order displays "YES" only if all the following conditions are met. Otherwise, display "NO": (1) the value in column D is greater than or equal to the region's minimum amount listed in the table H3:I9 (2) the text in column E begins with the four uppercase letters "SAVE" (3) the text in column E contains exactly 8 characters in total. Assume every region in column C will appear exactly once in H3:H9. See Examples

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

AND IF VLOOKUP XLOOKUP LEFT LEN INDEX MATCH XMATCH
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