Looking to find the correct formulas / Open to Ideas

Thanks for the response, appreciate the feedback. The photo below shows only part of the key, there's more that I don't have readily available. For any missing variables one could substitute "unknown variable" into the formula, and I can fill in later unless I'm missing why this couldn't be done or understood, which is possible. This is already well beyond my complete understanding so here's my best shot at explaining the key and the variables below.

My variable list in order (from A3 through G3) explained:

A3 - This is either "YES" or "NO". (2 options)
B3 - If A3 is "YES", a selection of multiple answer can be selected here. For now, 100amp, 200amp, 400amp (three options). If A3 is "NO", "N/A" will always be true.
C3 - This is either "1PH" or "3PH" (two options)
D3 - This is either "120/208V", "120/240V", or "347V/600V" (three options).
E3 - This is either "100A", "225A", or "400A" (three options).
F3 - This is either 18CC, 24CC, 30CC, 42CC, 60CC, 72CC, or 84CC (seven options)
G3 - This is either "AL" or "CU" (two options)

The picture below shows the key for only some of the part numbers that I need included. For this "key" in particular, A3, B3, C3, and G3 can be fixed. D3, E3, and F3 have multiple options still.

A3 - This is "NO"
B3 - This is "NO"
C3 - This is "3PH"
D3 - This is either "120/208V", "120/240V", or "347V/600V" (three options).
E3 - This is either "100A", "225A", or "400A" (three options).
F3 - This is either 18CC, 24CC, 30CC, 42CC, 60CC, 72CC, or 84CC (seven options)
G3 - This is "AL"

Attachment 855938

Your description is far from informative, the only relation from your variables and the code that you want to bring is the F3, but even those number don't correlate completely with what is supposed to bring back.
Have in mind that we can use the drop-down and see your list without you exposing it again.

Explain this code formation:
Excel 365 (Windows) 64 bit

	A	B	C
1	BOX PART NUMBERS	INTERIOR PART NUMBERS	TRIM PART NUMBERS
2	EZB2030RC	P1AL4A1-18	EZT2030 (S or F)
3	EZB2036RC	P1aL4A1-24	EZT2036 (S or F)
4	EZB2042RC	P1aL4A1-30	EZT2042 (S or F)
5	EZB2054RC	P1aL4A1-42	EZT2054 (S or F)
6	EZB2060RC	P1aL4A2-18	EZT2060 (S or F)
7	EZB2072RC	P1aL4A2-24	EZT2072 (S or F)
8	EZB2090RC	P1aL4A2-30
9		P1aL4A2-42
10		P1aL4A2-60
11		P1aL4A2-72
12		P1aL4A2-84
13		P1aL4A4-24
14		P1aL4A4-30
15		P1aL4A4-42
16		P1aL4A4-60
17		P1aL4A4-72
18		P1aL4A4-84
19		P1aL4C6-24
20		P1aL4C6-30
21		P1aL4C6-42
22		P1aL4C6-60
23		P1aL4C6-72
24		P1aL4C6-84

Sheet: PART NUMBER DATA