Spreadsheet: 727290d1617819984-find-and-match-a-text-value-for-a-corresponding-number-neyme-tvs
Sheet: Attributes_fillrate_processed

sku_id | class | attribute_name | value
5734900 | SMALL & MID FPTV|479 | 3D Technology | No
5734900 | SMALL & MID FPTV|479 | Abridged Product Name
5734900 | SMALL & MID FPTV|479 | Adjustable Stand Width | No
5734900 | SMALL & MID FPTV|479 | Backlight Type | Direct Lit
5734900 | SMALL & MID FPTV|479 | Battery Size (Remote Control) | AAA
5734900 | SMALL & MID FPTV|479 | Battery Type (Remote Control)
5734900 | SMALL & MID FPTV|479 | Bezel Width (Sides)
5734900 | SMALL & MID FPTV|479 | Bluetooth Enabled
5734900 | SMALL & MID FPTV|479 | Brightness | 180 candela per square meter |  |  |  | I would be really appreciative if the forum experts help me to come up with the formula to:
5734900 | SMALL & MID FPTV|479 | Built-in Speaker [NAME]
5734900 | SMALL & MID FPTV|479 | Built-In Speakers | Yes |  |  |  | For each combination of SKU ID in column 'A' and Attribute# (columns 'D'-'J') on "Adobe TV Category on PLP" tab --> return a value from "value" column D for a given SKU ID and Attribute # from "Attributes_fillrate_processed" tab. For example, for SKU ID 5734900 and Attribute1='Screen size' on "Adobe TV Category on PLP" tab, the value listed on "Attributes_fillrate_processed" tab is 23.6 inches.
5734900 | SMALL & MID FPTV|479 | Cable(s) Included | AC power
5734900 | SMALL & MID FPTV|479 | Closed Captioning | Yes |  |  |  | Any help is so much appreciated!
5734900 | SMALL & MID FPTV|479 | Color | Black
5734900 | SMALL & MID FPTV|479 | [NAME] | Black
5734900 | SMALL & MID FPTV|479 | Commercial Merchandise
5734900 | SMALL & MID FPTV|479 | Content Sharing
5734900 | SMALL & MID FPTV|479 | Curved Screen | No
5734900 | SMALL & MID FPTV|479 | Dimming Type
5734900 | SMALL & MID FPTV|479 | Display Type | LED
5734900 | SMALL & MID FPTV|479 | ENERGY STAR Certified | No
5734900 | SMALL & MID FPTV|479 | EPEAT Qualified | No
5734900 | SMALL & MID FPTV|479 | Ethernet Port(s) | No
5734900 | SMALL & MID FPTV|479 | HDBaseT Receiver
5734900 | SMALL & MID FPTV|479 | HDMI Audio Return Channel (ARC) | Yes
5734900 | SMALL & MID FPTV|479 | Headphone Jack
5734900 | SMALL & MID FPTV|479 | High Dynamic Range (HDR) | No
5734900 | SMALL & MID FPTV|479 | HTML Asset 1
5734900 | SMALL & MID FPTV|479 | HTML Asset 2
5734900 | SMALL & MID FPTV|479 | HTML Asset 3
5734900 | SMALL & MID FPTV|479 | HTML Asset 4
5734900 | SMALL & MID FPTV|479 | Indoor Or Outdoor Use
5734900 | SMALL & MID FPTV|479 | Language(s) Displayed | English
5734900 | SMALL & MID FPTV|479 | LED Panel Type | Standard LED
5734900 | SMALL & MID FPTV|479 | Local Dimming
5734900 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Labor | 1 Year
5734900 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Parts | 1 Year
5734900 | SMALL & MID FPTV|479 | Maximum Contrast Ratio (Native) | 41.66736111111111
5734900 | SMALL & MID FPTV|479 | Maximum Operating Temperature
5734900 | SMALL & MID FPTV|479 | Minimum Operating Temperature
5734900 | SMALL & MID FPTV|479 | Model Year | 2017
5734900 | SMALL & MID FPTV|479 | Motion Enhancement Technology | TruMotion 120
5734900 | SMALL & MID FPTV|479 | Mount Included
5734900 | SMALL & MID FPTV|479 | Network Compatibility | None
5734900 | SMALL & MID FPTV|479 | Number of Analog Audio Outputs
5734900 | SMALL & MID FPTV|479 | Number of Batteries Included (Remote Control) | 2
5734900 | SMALL & MID FPTV|479 | Number Of Batteries Required (Remote Control)
5734900 | SMALL & MID FPTV|479 | Number of Component Video Inputs | 0
5734900 | SMALL & MID FPTV|479 | Number of Composite Video Inputs | 0
5734900 | SMALL & MID FPTV|479 | Number of Digital Optical Audio Outputs | 0
5734900 | SMALL & MID FPTV|479 | Number of DVI Inputs | 0
5734900 | SMALL & MID FPTV|479 | Number of HDMI HDCP 2.2 Inputs | 1
5734900 | SMALL & MID FPTV|479 | Number of HDMI Inputs | 1
5734900 | SMALL & MID FPTV|479 | Number of RS-232 Inputs
5734900 | SMALL & MID FPTV|479 | Number of USB 2.0 Ports
5734900 | SMALL & MID FPTV|479 | Number of USB 3.0 Ports
5734900 | SMALL & MID FPTV|479 | Number Of USB Port(s) (Total) | 0
5734900 | SMALL & MID FPTV|479 | Number of VGA Ports
5734900 | SMALL & MID FPTV|479 | Peak Brightness
5734900 | SMALL & MID FPTV|479 | Product Depth With Stand | 5.8 inches
5734900 | SMALL & MID FPTV|479 | Product Depth Without Stand | 2.1 inches
5734900 | SMALL & MID FPTV|479 | Product Height With Stand | 15.2 inches
5734900 | SMALL & MID FPTV|479 | Product Height Without Stand | 13.6 inches
5734900 | SMALL & MID FPTV|479 | Product Weight With Stand | 7.5 pounds
5734900 | SMALL & MID FPTV|479 | Product Weight Without Stand | 7.1 pounds
5734900 | SMALL & MID FPTV|479 | Product Width | 21.9 inches
5734900 | SMALL & MID FPTV|479 | Quantum Dot Technology
5734900 | SMALL & MID FPTV|479 | Rechargeable Battery (Remote Control) | No
5734900 | SMALL & MID FPTV|479 | [NAME] | 60Hz
5734900 | SMALL & MID FPTV|479 | Remote Control Type | Standard
5734900 | SMALL & MID FPTV|479 | Resolution | HD (720p)
5734900 | SMALL & MID FPTV|479 | [NAME] | Yes
5734900 | SMALL & MID FPTV|479 | [NAME]
5734900 | SMALL & MID FPTV|479 | Screen Size | 23.6 inches
5734900 | SMALL & MID FPTV|479 | Screen Size Class | 24 inches
5734900 | SMALL & MID FPTV|479 | Series
5734900 | SMALL & MID FPTV|479 | Series Step Up
5734900 | SMALL & MID FPTV|479 | Smart Capable | No
5734900 | SMALL & MID FPTV|479 | Speaker Output | 6 watts
5734900 | SMALL & MID FPTV|479 | Specific Manufacturer Technologies
5734900 | SMALL & MID FPTV|479 | Stand Depth | 5.8 inches
5734900 | SMALL & MID FPTV|479 | Stand Included | Yes
5734900 | SMALL & MID FPTV|479 | [NAME] | 21.9 inches
5734900 | SMALL & MID FPTV|479 | Streaming Services
5734900 | SMALL & MID FPTV|479 | Surround Sound Supported
5734900 | SMALL & MID FPTV|479 | Text-To-Speech
5734900 | SMALL & MID FPTV|479 | TV [NAME] | Digital
5734900 | SMALL & MID FPTV|479 | TV/DVD Combo | No
5734900 | SMALL & MID FPTV|479 | V-Chip
5734900 | SMALL & MID FPTV|479 | Vertical Resolution
5734900 | SMALL & MID FPTV|479 | VESA Wall Mount Standard | 75mm x 75mm
5734900 | SMALL & MID FPTV|479 | Video Description
5734900 | SMALL & MID FPTV|479 | Voice Assistant Built-in | Amazon Alexa","Google Assistant
5734900 | SMALL & MID FPTV|479 | Wall Mount Included
5734900 | SMALL & MID FPTV|479 | Wall Mountable
5734900 | SMALL & MID FPTV|479 | Works With
5872505 | SMALL & MID FPTV|479 | 3D Technology | No
5872505 | SMALL & MID FPTV|479 | Abridged Product Name
5872505 | SMALL & MID FPTV|479 | Adjustable Stand Width | No
5872505 | SMALL & MID FPTV|479 | Backlight Type | Direct Lit
5872505 | SMALL & MID FPTV|479 | Battery Size (Remote Control) | AAA
5872505 | SMALL & MID FPTV|479 | Battery Type (Remote Control)
5872505 | SMALL & MID FPTV|479 | Bezel Width (Sides)
5872505 | SMALL & MID FPTV|479 | Bluetooth Enabled | No
5872505 | SMALL & MID FPTV|479 | Brightness | 170 candela per square meter
5872505 | SMALL & MID FPTV|479 | Built-in Speaker [NAME]
5872505 | SMALL & MID FPTV|479 | Built-In Speakers | Yes
5872505 | SMALL & MID FPTV|479 | Cable(s) Included | AC power
5872505 | SMALL & MID FPTV|479 | Closed Captioning | Yes
5872505 | SMALL & MID FPTV|479 | Color | Black
5872505 | SMALL & MID FPTV|479 | [NAME] | Black
5872505 | SMALL & MID FPTV|479 | Commercial Merchandise
5872505 | SMALL & MID FPTV|479 | Content Sharing
5872505 | SMALL & MID FPTV|479 | Curved Screen | No
5872505 | SMALL & MID FPTV|479 | Dimming Type
5872505 | SMALL & MID FPTV|479 | Display Type | LED
5872505 | SMALL & MID FPTV|479 | ENERGY STAR Certified | No
5872505 | SMALL & MID FPTV|479 | EPEAT Qualified | No
5872505 | SMALL & MID FPTV|479 | Ethernet Port(s) | No
5872505 | SMALL & MID FPTV|479 | HDBaseT Receiver | No
5872505 | SMALL & MID FPTV|479 | HDMI Audio Return Channel (ARC)
5872505 | SMALL & MID FPTV|479 | Headphone Jack | Yes
5872505 | SMALL & MID FPTV|479 | High Dynamic Range (HDR) | No
5872505 | SMALL & MID FPTV|479 | HTML Asset 1
5872505 | SMALL & MID FPTV|479 | HTML Asset 2
5872505 | SMALL & MID FPTV|479 | HTML Asset 3
5872505 | SMALL & MID FPTV|479 | HTML Asset 4
5872505 | SMALL & MID FPTV|479 | Indoor Or Outdoor Use | Indoor
5872505 | SMALL & MID FPTV|479 | Language(s) Displayed | English","French","Spanish
5872505 | SMALL & MID FPTV|479 | LED Panel Type | Standard LED
5872505 | SMALL & MID FPTV|479 | Local Dimming
5872505 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Labor | Not Available
5872505 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Parts | Not Available
5872505 | SMALL & MID FPTV|479 | Maximum Contrast Ratio (Native) | 100.0006944444444
5872505 | SMALL & MID FPTV|479 | Maximum Operating Temperature
5872505 | SMALL & MID FPTV|479 | Minimum Operating Temperature
5872505 | SMALL & MID FPTV|479 | Model Year | 2017
5872505 | SMALL & MID FPTV|479 | Motion Enhancement Technology
5872505 | SMALL & MID FPTV|479 | Mount Included
5872505 | SMALL & MID FPTV|479 | Network Compatibility | None
5872505 | SMALL & MID FPTV|479 | Number of Analog Audio Outputs | 0
5872505 | SMALL & MID FPTV|479 | Number of Batteries Included (Remote Control) | 0
5872505 | SMALL & MID FPTV|479 | Number Of Batteries Required (Remote Control) | 2
5872505 | SMALL & MID FPTV|479 | Number of Component Video Inputs | 1
5872505 | SMALL & MID FPTV|479 | Number of Composite Video Inputs | 1
5872505 | SMALL & MID FPTV|479 | Number of Digital Optical Audio Outputs | 0
5872505 | SMALL & MID FPTV|479 | Number of DVI Inputs | 0
5872505 | SMALL & MID FPTV|479 | Number of HDMI HDCP 2.2 Inputs | 0
5872505 | SMALL & MID FPTV|479 | Number of HDMI Inputs | 3
5872505 | SMALL & MID FPTV|479 | Number of RS-232 Inputs | 0
5872505 | SMALL & MID FPTV|479 | Number of USB 2.0 Ports
5872505 | SMALL & MID FPTV|479 | Number of USB 3.0 Ports
5872505 | SMALL & MID FPTV|479 | Number Of USB Port(s) (Total) | 0
5872505 | SMALL & MID FPTV|479 | Number of VGA Ports | 1
5872505 | SMALL & MID FPTV|479 | Peak Brightness
5872505 | SMALL & MID FPTV|479 | Product Depth With Stand | 8.2 inches
5872505 | SMALL & MID FPTV|479 | Product Depth Without Stand | 3.2 inches
5872505 | SMALL & MID FPTV|479 | Product Height With Stand | 18.9 inches
5872505 | SMALL & MID FPTV|479 | Product Height Without Stand | 17.4 inches
5872505 | SMALL & MID FPTV|479 | Product Weight With Stand | 11.5 pounds
5872505 | SMALL & MID FPTV|479 | Product Weight Without Stand | 11.2 pounds
5872505 | SMALL & MID FPTV|479 | Product Width | 28.8 inches
5872505 | SMALL & MID FPTV|479 | Quantum Dot Technology
5872505 | SMALL & MID FPTV|479 | Rechargeable Battery (Remote Control) | No
5872505 | SMALL & MID FPTV|479 | [NAME] | 60Hz
5872505 | SMALL & MID FPTV|479 | Remote Control Type | Standard
5872505 | SMALL & MID FPTV|479 | Resolution | HD (720p)
5872505 | SMALL & MID FPTV|479 | [NAME] | Yes
5872505 | SMALL & MID FPTV|479 | [NAME]
5872505 | SMALL & MID FPTV|479 | Screen Size | 31.5 inches
5872505 | SMALL & MID FPTV|479 | Screen Size Class | 32 inches
5872505 | SMALL & MID FPTV|479 | Series
5872505 | SMALL & MID FPTV|479 | Series Step Up
5872505 | SMALL & MID FPTV|479 | Smart Capable | No
5872505 | SMALL & MID FPTV|479 | Speaker Output | 16 watts
5872505 | SMALL & MID FPTV|479 | Specific Manufacturer Technologies | TV/DVD Combo
5872505 | SMALL & MID FPTV|479 | Stand Depth
5872505 | SMALL & MID FPTV|479 | Stand Included | Yes
5872505 | SMALL & MID FPTV|479 | [NAME]
5872505 | SMALL & MID FPTV|479 | Streaming Services
5872505 | SMALL & MID FPTV|479 | Surround Sound Supported
5872505 | SMALL & MID FPTV|479 | Text-To-Speech | No
5872505 | SMALL & MID FPTV|479 | TV [NAME] | Digital
5872505 | SMALL & MID FPTV|479 | TV/DVD Combo | Yes
5872505 | SMALL & MID FPTV|479 | V-Chip | Yes
5872505 | SMALL & MID FPTV|479 | Vertical Resolution
5872505 | SMALL & MID FPTV|479 | VESA Wall Mount Standard | 200mm x 100mm
5872505 | SMALL & MID FPTV|479 | Video Description
5872505 | SMALL & MID FPTV|479 | Voice Assistant Built-in | No
5872505 | SMALL & MID FPTV|479 | Wall Mount Included
5872505 | SMALL & MID FPTV|479 | Wall Mountable
5872505 | SMALL & MID FPTV|479 | Works With
5900969 | SMALL & MID FPTV|479 | 3D Technology | No
5900969 | SMALL & MID FPTV|479 | Abridged Product Name
5900969 | SMALL & MID FPTV|479 | Backlight Type | Edge Lit
5900969 | SMALL & MID FPTV|479 | Battery Size (Remote Control)
5900969 | SMALL & MID FPTV|479 | Battery Type (Remote Control)
5900969 | SMALL & MID FPTV|479 | Bezel Width (Sides)
5900969 | SMALL & MID FPTV|479 | Bluetooth Enabled
5900969 | SMALL & MID FPTV|479 | Brightness | 500 candela per square meter
5900969 | SMALL & MID FPTV|479 | Built-in Speaker [NAME]
5900969 | SMALL & MID FPTV|479 | Built-In Speakers | Yes
5900969 | SMALL & MID FPTV|479 | Cable(s) Included
5900969 | SMALL & MID FPTV|479 | Closed Captioning
5900969 | SMALL & MID FPTV|479 | Color | Black
5900969 | SMALL & MID FPTV|479 | [NAME] | Black
5900969 | SMALL & MID FPTV|479 | Commercial Merchandise
5900969 | SMALL & MID FPTV|479 | Content Sharing
5900969 | SMALL & MID FPTV|479 | Curved Screen | No
5900969 | SMALL & MID FPTV|479 | Dimming Type
5900969 | SMALL & MID FPTV|479 | Display Type | LED
5900969 | SMALL & MID FPTV|479 | ENERGY STAR Certified | No
5900969 | SMALL & MID FPTV|479 | EPEAT Qualified | No
5900969 | SMALL & MID FPTV|479 | Ethernet Port(s)
5900969 | SMALL & MID FPTV|479 | HDBaseT Receiver
5900969 | SMALL & MID FPTV|479 | HDMI Audio Return Channel (ARC)
5900969 | SMALL & MID FPTV|479 | Headphone Jack
5900969 | SMALL & MID FPTV|479 | High Dynamic Range (HDR) | No
5900969 | SMALL & MID FPTV|479 | HTML Asset 1
5900969 | SMALL & MID FPTV|479 | HTML Asset 2
5900969 | SMALL & MID FPTV|479 | HTML Asset 3
5900969 | SMALL & MID FPTV|479 | HTML Asset 4
5900969 | SMALL & MID FPTV|479 | Indoor Or Outdoor Use | Outdoor
5900969 | SMALL & MID FPTV|479 | Language(s) Displayed
5900969 | SMALL & MID FPTV|479 | LED Panel Type | Standard LED
5900969 | SMALL & MID FPTV|479 | Local Dimming
5900969 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Labor | 2 years
5900969 | SMALL & MID FPTV|479 | Manufacturer's Warranty - Parts | 2 years
5900969 | SMALL & MID FPTV|479 | Maximum Contrast Ratio (Native) | 45.83402777777778
5900969 | SMALL & MID FPTV|479 | Maximum Operating Temperature
5900969 | SMALL & MID FPTV|479 | Minimum Operating Temperature
5900969 | SMALL & MID FPTV|479 | Model Year | 2020
5900969 | SMALL & MID FPTV|479 | Motion Enhancement Technology
5900969 | SMALL & MID FPTV|479 | Mount Included
5900969 | SMALL & MID FPTV|479 | Network Compatibility
5900969 | SMALL & MID FPTV|479 | Number of Analog Audio Outputs
5900969 | SMALL & MID FPTV|479 | Number of Batteries Included (Remote Control)
5900969 | SMALL & MID FPTV|479 | Number Of Batteries Required (Remote Control)
5900969 | SMALL & MID FPTV|479 | Number of Component Video Inputs | 1
5900969 | SMALL & MID FPTV|479 | Number of Composite Video Inputs | 1
5900969 | SMALL & MID FPTV|479 | Number of Digital Optical Audio Outputs | 1
5900969 | SMALL & MID FPTV|479 | Number of DVI Inputs | 0
5900969 | SMALL & MID FPTV|479 | Number of HDMI HDCP 2.2 Inputs
5900969 | SMALL & MID FPTV|479 | Number of HDMI Inputs | 3
5900969 | SMALL & MID FPTV|479 | Number of RS-232 Inputs
5900969 | SMALL & MID FPTV|479 | Number of USB 2.0 Ports
5900969 | SMALL & MID FPTV|479 | Number of USB 3.0 Ports
5900969 | SMALL & MID FPTV|479 | Number Of USB Port(s) (Total) | 1
5900969 | PREMIUM FPTV|306 | Number of VGA Ports | 1
5900969 | PREMIUM FPTV|306 | Peak Brightness
5900969 | PREMIUM FPTV|306 | Product Depth Without Stand | 3.9 inches
5900969 | PREMIUM FPTV|306 | Product Height Without Stand | 29.6 inches
5900969 | PREMIUM FPTV|306 | Product Weight Without Stand | 61.2 pounds
5900969 | PREMIUM FPTV|306 | Product Width | 50.5 inches
5900969 | PREMIUM FPTV|306 | Quantum Dot Technology
5900969 | PREMIUM FPTV|306 | Rechargeable Battery (Remote Control) | No
5900969 | PREMIUM FPTV|306 | [NAME] | 60Hz
5900969 | PREMIUM FPTV|306 | Remote Control Type | Universal
5900969 | PREMIUM FPTV|306 | Resolution | 4K (2160p)
5900969 | PREMIUM FPTV|306 | [NAME] | Yes
5900969 | PREMIUM FPTV|306 | [NAME]
5900969 | PREMIUM FPTV|306 | Screen Size | 55 inches
5900969 | PREMIUM FPTV|306 | Screen Size Class | 55 inches
5900969 | PREMIUM FPTV|306 | Series
5900969 | PREMIUM FPTV|306 | Series Step Up
5900969 | PREMIUM FPTV|306 | Smart Capable | No
5900969 | PREMIUM FPTV|306 | Speaker Output | 10 watts
5900969 | PREMIUM FPTV|306 | Specific Manufacturer Technologies | Color temperature adjustment, Noise Reduction
5900969 | PREMIUM FPTV|306 | Stand Included | No
5900969 | PREMIUM FPTV|306 | Streaming Services
5900969 | PREMIUM FPTV|306 | Surround Sound Supported
5900969 | PREMIUM FPTV|306 | Text-To-Speech
5900969 | PREMIUM FPTV|306 | TV [NAME] | Digital
5900969 | PREMIUM FPTV|306 | TV/DVD Combo
5900969 | PREMIUM FPTV|306 | V-Chip | Yes
5900969 | PREMIUM FPTV|306 | Vertical Resolution
5900969 | PREMIUM FPTV|306 | VESA Wall Mount Standard | 400mm x 300mm
5900969 | PREMIUM FPTV|306 | Video Description
5900969 | PREMIUM FPTV|306 | Voice Assistant Built-in | Not Applicable
5900969 | PREMIUM FPTV|306 | Wall Mount Included
5900969 | PREMIUM FPTV|306 | Wall Mountable
5900969 | PREMIUM FPTV|306 | Works With