Spreadsheet: 805697d1668845086-highlight-cell-with-unique-number-based-off-vlookup-outcome-sample-sheet
Sheet: Input

Tracker-String | Date | Time | SP1 | SP2 | SP3 | SP4 | SP5 | SP6 | SP7 | SP8 | SP9 | SP10 | SP11 | SP12 | SP13 | SP14 | SP15 | SP16 | SP17 | SP18 | SP19 | SP20 | SP21 | SP22 | SP23 | SP24 | SP25 | SP26 | SP27 | SP28
T1024 - 1 | 2020-09-15 00:00:00 | 05:48:10 | 0T1565049151180319 | 0T1565049150930319 | 0T1565049151150319 | 2T13K2031033415118 | 2T13K2031032745118 | 2T13K2031032835118 | 2T13K2031032015118 | 2T13K2031033605118 | 2T13K2031033915118 | 2T13K2031031945118 | 2T13K2031032755118 | 2T13K2031033395118 | 2T13K2031028785118 | 2T13K2031031885118 | 2T13K2031033325118 | 0T1565048692100319 | 2T13K2031032765118 | [NAME] | 0T1565048691900319 | 0T1565048672880219 | 0T1565048260130219 | 0T1565048691800319 | 0T1565048691980319 | 0T1565048692230319 | 0T1565048260170219 | 0T1565048692120319 | 0T1565048692080319 | 0T1565048691930319
T1024 - 2 | 2020-09-15 00:00:00 | 05:48:10 | 0T1416216621130319 | 0T1416216624190319 | 0T1416216624290319 | 0T1416216590610319 | 0T1416216590580319 | 0T1416216623370319 | 0T1416216621250319 | 0T1565049151640319 | 0T1565049150810319 | 0T1565049150510319 | 0T1565049150940319 | 0T1565049150970319 | 0T1565049150990319 | 0T1565049150830319 | 0T1565049151070319 | 0T1565049150950319 | 0T1565049151370319 | 0T1565049151230319 | 0T1565049151200319 | 0T1565049150900319 | 0T1565049126390319 | 0T1565049116900319 | 0T1565048281050219 | 0T1565049126670319 | 0T1565049126790319 | 0T1565049151320319 | 0T1565049150520319 | 0T1565049150650319
T1024 - 3 | 2020-09-15 00:00:00 | 05:48:10 | 0T1516224940600319 | 0T1516224941150319 | 0T1516224940830319 | 0T1516224930950319 | 0T1516224960350319 | 0T1516224960560319 | [NAME] | 0T1516224960570319 | 0T1516225380200419 | 0T1416216630440319 | 0T1416216630320319 | 0T1416216630740319 | 0T1416219440100319 | 0T1416216630400319 | 0T1416216630200319 | 0T1416216630670319 | 0T1416216630610319 | 0T1416216630340319 | 0T1416216622670319 | 0T1416219471530319 | 0T1416216630220319 | 0T1416219460100319 | 0T1416216590080319 | 0T1416216630240319 | 0T1416216624170319 | 0T1416216624270319 | 0T1416216623820319 | 0T1416216623900319
T1025 - 1 | 2020-09-15 00:00:00 | 05:52:08 | 3T1565044183925118 | 3T1565044186075118 | 3T1565044184315118 | 3T1565044184095118 | 3T1565044184665118 | 3T1565044186755118 | 3T1565044182545118 | 3T1565044185245118 | 3T1565044185085118 | 3T1565044184435118 | 3T1565044184605118 | 0T1565048690590319 | 0T1565048690650319 | 0T1565048690460319 | 0T1565048690490319 | 0T1565048690360319 | 0T1565048641140219 | 0T1565048673100219 | 0T1565048672150219 | 0T1565048690510319 | 0T1565048680690219 | 0T1565048680710219 | 0T1565048680740219 | 0T1565048680650219 | 0T1565048691020319 | 0T1565048691030319 | 0T1565048691040319 | 0T1565048691610319
T1025 - 2 | 2020-09-15 00:00:00 | 05:52:08 | 0U24K2031015680419 | 0U24K2031014910419 | 0U24K2031014860419 | 0U24K2031014550419 | 0U24K2031014870419 | 0U24K2031015000419 | 0U24K2031015640419 | 0U24K2031014610419 | 0U24K2031016050419 | [NAME] | 0U24K2031014600419 | 0U24K2031016060419 | 0U24K2031014930419 | 0U24K2031014920419 | 0U24K2031014900419 | 0T1416222650440319 | 0T1416220570250319 | 0T1416220440110319 | 0T1416222660230319 | 0T1416222660540319 | 0T1416222660420319 | 0T1416222660650319 | 0T1416222660300319 | 0T1416222670240319 | 0T1416222650120319 | 0T1416222660440319 | 0T1416220500110319 | 0T1416222670270319
T1025 - 3 | 2020-09-15 00:00:00 | 05:52:08 | 0T1516224940200319 | 0T1516225390030419 | 0T1516225390330419 | 0T1516225410080419 | 2T12K2031075055018 | 2T12K2031074675018 | 2T12K2031074665018 | 2T12K2031074645018 | 2T12K2031072925018 | 2T12K2031074475018 | 2T12K2031072345018 | 2T12K2031074545018 | 2T12K2031075015018 | 2T12K2031075555018 | 2T12K2031075345018 | 2T12K2031074725018 | 0U24K2031015660419 | 0U24K2031014660419 | 0U24K2031015220419 | 0U24K2031014950419 | 0U24K2031014090419 | 0U24K2031015720419 | 0U24K2031015140419 | 0U24K2031015700419 | 0U24K2031015750419 | 0U24K2031014960419 | 0U24K2031015110419 | 0U24K2031015100419