Spreadsheet: 713818d1610960259-lookup-for-4-criteria-and-retrieve-the-nearest-match-nearest_value-multiple-criterias
Sheet: list 1

CONCATENATED | TYPE | FR | WIDTH | HEIGHT | Exact Match | Nearest (FR Priority) | Nearest (Width Priority) | Nearest (Height Priority)
AD-01A.[PHONE] | AD-01A | 120 | 700 | 2300
[NAME] | AD-01A | 120 | 770 | 2188
[NAME] | AD-01A | 120 | 930 | 2300
AD-01B.[PHONE] | AD-01B | 0 | 660 | 2300
AD-01B.[PHONE] | AD-01B | 90 | 865 | 2300
AD-02.000.1300.2300 | AD-02 | 0 | 1300 | 2300
AD-04A.120.600.740 | AD-04A | 120 | 600 | 740
AD-04A.120.800.800 | AD-04A | 120 | 800 | 800
AD-04B.[PHONE] | AD-04B | 0 | 800 | 2300
AD-04B.[PHONE] | AD-04B | 60 | 800 | 2300
AD-04B.[PHONE] | AD-04B | 90 | 800 | 2300
ED-01.120.1100.3100 | ED-01 | 120 | 1100 | 3100
ED-02.000.1100.2300 | ED-02 | 0 | 1100 | 2300
ED-[PHONE] | ED-02 | 0 | 900 | 2300
ED-02.060.1100.2300 | ED-02 | 60 | 1100 | 2300
[NAME] | ED-02 | 60 | 1100 | 2310
ED-[PHONE] | ED-02 | 60 | 600 | 2300
ED-[PHONE] | ED-02 | 60 | 900 | 2300
ED-02.090.1100.2300 | ED-02 | 90 | 1100 | 2300
ED-[PHONE] | ED-02 | 90 | 900 | 2300
ED-02.120.1100.2300 | ED-02 | 120 | 1100 | 2300
ED-02_EO.[PHONE] | ED-02_EO | 60 | 600 | 2300
ED-02_EO.[PHONE] | ED-02_EO | 120 | 700 | 2300
ED-03.060.1800.3100 | ED-03 | 60 | 1800 | 3100
ED-03.060.2000.3100 | ED-03 | 60 | 2000 | 3100
ED-03_EO.060.3000.3100 | ED-03_EO | 60 | 3000 | 3100
[NAME] | ED-04 | 60 | 1400 | 2300
ED-04_EO.060.1400.2300 | ED-04_EO | 60 | 1400 | 2300
ED-09.060.1100.2300 | ED-09 | 60 | 1100 | 2300
ED-09_EO.000.1100.2300 | ED-09_EO | 0 | 1100 | 2300
ED-09_EO.060.1100.2300 | ED-09_EO | 60 | 1100 | 2300
ED-09_EO.120.1100.2300 | ED-09_EO | 120 | 1100 | 2300
ED-[PHONE] | ED-10 | 60 | 600 | 2600
ED-[PHONE] | ED-10 | 60 | 900 | 2600
ED-10_EO.[PHONE] | ED-10_EO | 60 | 600 | 2600
MD-01.060.1100.2110 | MD-01 | 60 | 1100 | 2110
MD-[PHONE] | MD-01 | 60 | 700 | 2110
MD-[PHONE] | MD-01 | 120 | 900 | 2110
MD-02.000.1100.2300 | MD-02 | 0 | 1100 | 2300
MD-[PHONE] | MD-02 | 0 | 900 | 2300
MD-02.060.1000.2310 | MD-02 | 60 | 1000 | 2310
MD-02.060.1100.2310 | MD-02 | 60 | 1100 | 2310
[NAME] | MD-02 | 60 | 1200 | 2310
MD-02.060.1220.2310 | MD-02 | 60 | 1220 | 2310
MD-02.060.1260.2330 | MD-02 | 60 | 1260 | 2330
MD-[PHONE] | MD-02 | 60 | 900 | 2310
MD-02.060.1100.2300 | MD-02 | 60 | 1100 | 2300
MD-02.060.1200.2300 | MD-02 | 60 | 1200 | 2300
MD-[PHONE] | MD-02 | 60 | 700 | 2300
MD-[PHONE] | MD-02 | 60 | 700 | 2310
MD-[PHONE] | MD-02 | 60 | 900 | 2300
MD-02.090.1000.2310 | MD-02 | 90 | 1000 | 2310
MD-02.090.1100.2310 | MD-02 | 90 | 1100 | 2310
MD-02.090.1200.2310 | MD-02 | 90 | 1200 | 2310
MD-[PHONE] | MD-02 | 90 | 900 | 2310
MD-02.090.1100.2300 | MD-02 | 90 | 1100 | 2300
MD-02.090.1200.2300 | MD-02 | 90 | 1200 | 2300
MD-[PHONE] | MD-02 | 90 | 700 | 2300
MD-[PHONE] | MD-02 | 90 | 800 | 2300
MD-[PHONE] | MD-02 | 90 | 900 | 2300
MD-[PHONE] | MD-02 | 90 | 900 | 2310
MD-02.120.1000.2310 | MD-02 | 120 | 1000 | 2310
MD-02.120.1100.2310 | MD-02 | 120 | 1100 | 2310
MD-02.120.1200.2310 | MD-02 | 120 | 1200 | 2310
MD-02.120.1220.2310 | MD-02 | 120 | 1220 | 2310
MD-02.120.1260.2330 | MD-02 | 120 | 1260 | 2330
MD-02.120.1650.2390 | MD-02 | 120 | 1650 | 2390
MD-[PHONE] | MD-02 | 120 | 700 | 2310
MD-[PHONE] | MD-02 | 120 | 900 | 2310
MD-[PHONE] | MD-02 | 120 | 920 | 2310
MD-02.120.1100.2300 | MD-02 | 120 | 1100 | 2300
MD-02.120.1200.2300 | MD-02 | 120 | 1200 | 2300
MD-[PHONE] | MD-02 | 120 | 700 | 2300
MD-[PHONE] | MD-02 | 120 | 700 | 2310
MD-[PHONE] | MD-02 | 120 | 900 | 2300
MD-03.060.3100.3110 | MD-03 | 60 | 3100 | 3110
MD-03.060.3500.3110 | MD-03 | 60 | 3500 | 3110
MD-03.090.3100.3110 | MD-03 | 90 | 3100 | 3110
MD-03.120.3100.3110 | MD-03 | 120 | 3100 | 3110
MD-04.000.1500.2300 | MD-04 | 0 | 1500 | 2300
MD-04.000.1800.2300 | MD-04 | 0 | 1800 | 2300
[NAME] | MD-04 | 60 | 1200 | 2310
[NAME] | MD-04 | 60 | 1500 | 2310
MD-04.060.1800.2310 | MD-04 | 60 | 1800 | 2310
MD-04.060.2100.2310 | MD-04 | 60 | 2100 | 2310
MD-04.060.2400.2310 | MD-04 | 60 | 2400 | 2310
MD-[PHONE] | MD-04 | 60 | 900 | 2310
MD-04.060.1500.2300 | MD-04 | 60 | 1500 | 2300
MD-04.060.1700.2300 | MD-04 | 60 | 1700 | 2300
MD-04.060.1800.2300 | MD-04 | 60 | 1800 | 2300
MD-04.060.2100.2300 | MD-04 | 60 | 2100 | 2300
MD-04.090.1200.2310 | MD-04 | 90 | 1200 | 2310
MD-04.090.1500.2310 | MD-04 | 90 | 1500 | 2310
MD-04.090.1600.2310 | MD-04 | 90 | 1600 | 2310
MD-04.090.1800.2310 | MD-04 | 90 | 1800 | 2310
MD-04.090.2100.2310 | MD-04 | 90 | 2100 | 2310
MD-04.090.2400.2310 | MD-04 | 90 | 2400 | 2310
MD-04.090.1500.2300 | MD-04 | 90 | 1500 | 2300
MD-04.090.1800.2300 | MD-04 | 90 | 1800 | 2300
[NAME] | MD-04 | 120 | 1000 | 2310
MD-04.120.1200.2310 | MD-04 | 120 | 1200 | 2310
MD-04.120.1500.2310 | MD-04 | 120 | 1500 | 2310
MD-04.120.1800.2310 | MD-04 | 120 | 1800 | 2310
[NAME] | MD-04 | 120 | 2100 | 2310
MD-04.120.2400.2310 | MD-04 | 120 | 2400 | 2310
MD-[PHONE] | MD-04 | 120 | 900 | 2310
MD-04.120.1200.2300 | MD-04 | 120 | 1200 | 2300
MD-04.120.1500.2300 | MD-04 | 120 | 1500 | 2300
MD-04.120.1800.2300 | MD-04 | 120 | 1800 | 2300
MD-[PHONE] | MD-04 | 120 | 900 | 2300
MD-05.060.1200.2310 | MD-05 | 60 | 1200 | 2310
MD-05.060.1200.2300 | MD-05 | 60 | 1200 | 2300
[NAME] | MD-05 | 90 | 1200 | 2310
MD-05.090.1500.2310 | MD-05 | 90 | 1500 | 2310
[NAME] | MD-05 | 90 | 1200 | 2300
MD-05.120.1200.2310 | MD-05 | 120 | 1200 | 2310
MD-05.120.1500.2310 | MD-05 | 120 | 1500 | 2310
MD-05.120.1200.2300 | MD-05 | 120 | 1200 | 2300
MD-10.090.1800.2300 | MD-10 | 90 | 1800 | 2300
[NAME] | MD-11 | 90 | 2400 | 2310
MD-12.060.3800.2510 | MD-12 | 60 | 3800 | 2510
MD-12.090.3800.2510 | MD-12 | 90 | 3800 | 2510
MD-12.120.3800.2510 | MD-12 | 120 | 3800 | 2510
MD-13.120.2200.2710 | MD-13 | 120 | 2200 | 2710
MD-[PHONE] | MD-16 | 0 | 800 | 2210
MD-16.060.1200.2210 | MD-16 | 60 | 1200 | 2210
MD-16.090.1100.2210 | MD-16 | 90 | 1100 | 2210
MD-16.120.1200.2210 | MD-16 | 120 | 1200 | 2210
MD-16.120.1260.2230 | MD-16 | 120 | 1260 | 2230
MD-[PHONE] | MD-16 | 120 | 800 | 2210
MD-[PHONE] | MD-16 | 120 | 900 | 2210
[NAME] | MD-17 | 0 | 1100 | 2030
MD-17.000.1100.2243 | MD-17 | 0 | 1100 | 2243
MD-[PHONE] | MD-17 | 0 | 930 | 2300
MD-[PHONE] | MD-17 | 0 | 930 | 2343
MD-17.060.1100.2030 | MD-17 | 60 | 1100 | 2030
MD-17.060.1100.2243 | MD-17 | 60 | 1100 | 2243
PD-01.060.1100.3100 | PD-01 | 60 | 1100 | 3100
PD-01.090.1100.3100 | PD-01 | 90 | 1100 | 3100
PD-02.000.1100.2300 | PD-02 | 0 | 1100 | 2300
PD-[PHONE] | PD-02 | 0 | 900 | 2300
PD-02.060.1100.2515 | PD-02 | 60 | 1100 | 2515
PD-02.060.1100.2765 | PD-02 | 60 | 1100 | 2765
PD-02.060.1100.3065 | PD-02 | 60 | 1100 | 3065
PD-[PHONE] | PD-02 | 60 | 900 | 2515
PD-[PHONE] | PD-02 | 60 | 900 | 2565
PD-[PHONE] | PD-02 | 60 | 900 | 2715
PD-[PHONE] | PD-02 | 60 | 900 | 2765
PD-[PHONE] | PD-02 | 60 | 900 | 2915
PD-02.090.1100.2515 | PD-02 | 90 | 1100 | 2515
PD-02.090.1100.2765 | PD-02 | 90 | 1100 | 2765
PD-02.090.1100.3065 | PD-02 | 90 | 1100 | 3065
PD-[PHONE] | PD-02 | 90 | 900 | 2565
PD-[PHONE] | PD-02 | 90 | 900 | 2765
PD-02_EO.000.1100.2300 | PD-02_EO | 0 | 1100 | 2300
PD-02_EO.[PHONE] | PD-02_EO | 0 | 900 | 2300
PD-02_EO.060.1100.2490 | PD-02_EO | 60 | 1100 | 2490
PD-02_EO.[PHONE] | PD-02_EO | 60 | 900 | 2490
PD-02_EO.090.1100.2490 | PD-02_EO | 90 | 1100 | 2490
PD-02_EO.[PHONE] | PD-02_EO | 90 | 900 | 2490
PD-04.000.1800.2300 | PD-04 | 0 | 1800 | 2300
PD-04.060.1800.2415 | PD-04 | 60 | 1800 | 2415
PD-04.060.1800.2915 | PD-04 | 60 | 1800 | 2915
[NAME] | PD-04 | 60 | 2300 | 3065
PD-04_EO.000.1800.2300 | PD-04_EO | 0 | 1800 | 2300
PD-04_EO.060.1800.2490 | PD-04_EO | 60 | 1800 | 2490
PD-06_EO.[PHONE] | PD-06_EO | 90 | 900 | 2300
PD-08_EO.[PHONE] | PD-08_EO | 0 | 900 | 2300
PD-08_EO.[PHONE] | PD-08_EO | 60 | 900 | 2490
ST-01.060.1500.2200 | ST-01 | 60 | 1500 | 2200
ST-02.060.1800.2200 | ST-02 | 60 | 1800 | 2200
TD-[PHONE] | TD-01 | 90 | 900 | 3100
TD-02.000.1100.2300 | TD-02 | 0 | 1100 | 2300
TD-[PHONE] | TD-02 | 0 | 700 | 2300
TD-[PHONE] | TD-02 | 0 | 900 | 2300
TD-02.060.1100.2300 | TD-02 | 60 | 1100 | 2300
TD-[PHONE] | TD-02 | 60 | 900 | 2300
TD-02.090.1100.2300 | TD-02 | 90 | 1100 | 2300
TD-[PHONE] | TD-02 | 90 | 900 | 2300
TD-02.120.1100.2300 | TD-02 | 120 | 1100 | 2300
TD-[PHONE] | TD-02 | 120 | 700 | 2300
TD-[PHONE] | TD-02 | 120 | 900 | 2300
TD-04.000.1400.2300 | TD-04 | 0 | 1400 | 2300
TD-04.000.1800.2300 | TD-04 | 0 | 1800 | 2300
TD-04.060.1800.2300 | TD-04 | 60 | 1800 | 2300
TD-04.060.1900.2300 | TD-04 | 60 | 1900 | 2300
TD-04.090.1700.2300 | TD-04 | 90 | 1700 | 2300
TD-04.090.1800.2300 | TD-04 | 90 | 1800 | 2300
TD-04.120.1200.2300 | TD-04 | 120 | 1200 | 2300
TD-04.120.1800.2300 | TD-04 | 120 | 1800 | 2300
TD-06.000.1500.2300 | TD-06 | 0 | 1500 | 2300
TD-06.090.1500.2300 | TD-06 | 90 | 1500 | 2300
TD-08.000.2300.2770 | TD-08 | 0 | 2300 | 2770
TD-10.000.1800.2300 | TD-10 | 0 | 1800 | 2300
TD-10.060.1800.2300 | TD-10 | 60 | 1800 | 2300
TD-10.090.1800.2300 | TD-10 | 90 | 1800 | 2300
[NAME] | TD-10 | 120 | 1200 | 2300
TD-11.000.1100.2300 | TD-11 | 0 | 1100 | 2300
TD-[PHONE] | TD-11 | 0 | 900 | 2300
TD-11.060.1100.2300 | TD-11 | 60 | 1100 | 2300
TD-[PHONE] | TD-11 | 60 | 900 | 2300
TM-[PHONE] | TM-01 | 0 | 900 | 2310
TM-01.060.1000.2310 | TM-01 | 60 | 1000 | 2310
TM-[PHONE] | TM-01 | 60 | 900 | 2310
[NAME] | TM-01 | 90 | 1000 | 2310
TM-02.060.1500.2310 | TM-02 | 60 | 1500 | 2310
TM-02.060.1800.2310 | TM-02 | 60 | 1800 | 2310
[NAME] | TM-02 | 90 | 1500 | 2310
[NAME] | TM-02 | 90 | 1800 | 2310
WD-01.000.1000.2200 | WD-01 | 0 | 1000 | 2200
[NAME] | WD-01 | 60 | 1000 | 2200
WD-02.000.1000.2200 | WD-02 | 0 | 1000 | 2200
WD-[PHONE] | WD-02 | 0 | 800 | 2200
WD-02.060.1000.2200 | WD-02 | 60 | 1000 | 2200
WD-03.000.1000.2200 | WD-03 | 0 | 1000 | 2200