Spreadsheet: 769094d1645286542-excel-v-lookup-needed-for-variable-start-time-end-time-combinations-revised-sample-data-for-vlookup-query
Sheet: Sheet1

 |  |  |  |  |  | Need VLOOKUP HERE
Data Set 1
Company | Day | Segment Name | Segment Start Time | Segment End Time | Duration | [NAME] | Sum Value
A | Monday | A1 | 18:30:25 | 18:35:22 |  | need vlookup average as 446.833 | need vlookup sum as 2681 here
B | Wednesday | B2 | 18:28:45 | 18:31:33 |  | need vlookup average as 716.25 | need vlookup sum as 2865 here
C | Saturday | [NAME] | 18:27:53 | 18:38:21 |  | need vlookup average as 543.25 | need vlookup sum as 6519 here
A | Sunday | A2 | 18:33:20 | 18:33:40 |  | need vlookup average as 897 here | need vlookup sum as 897 here
Data Set 2 - Min on Min Data
Company | Day | Start Time | End Time | Value
A | Monday | 18:25:00 | 18:25:00 | 396
A | Monday | 18:26:00 | 18:26:00 | 513
A | Monday | 18:27:00 | 18:27:00 | 421
A | Monday | 18:28:00 | 18:28:00 | 622
A | Monday | 18:29:00 | 18:29:00 | 632
A | Monday | 18:30:00 | 18:30:00 | 135
A | Monday | 18:31:00 | 18:31:00 | 792
A | Monday | 18:32:00 | 18:32:00 | 182
A | Monday | 18:33:00 | 18:33:00 | 855
A | Monday | 18:34:00 | 18:34:00 | 174
A | Monday | 18:35:00 | 18:35:00 | 543
A | Monday | 18:36:00 | 18:36:00 | 433
A | Monday | 18:37:00 | 18:37:00 | 128
A | Monday | 18:38:00 | 18:38:00 | 903
A | Monday | 18:39:00 | 18:39:00 | 53
A | Monday | 18:40:00 | 18:40:00 | 563
A | Tuesday | 18:25:00 | 18:25:00 | 142
A | Tuesday | 18:26:00 | 18:26:00 | 966
A | Tuesday | 18:27:00 | 18:27:00 | 978
A | Tuesday | 18:28:00 | 18:28:00 | 701
A | Tuesday | 18:29:00 | 18:29:00 | 966
A | Tuesday | 18:30:00 | 18:30:00 | 92
A | Tuesday | 18:31:00 | 18:31:00 | 693
A | Tuesday | 18:32:00 | 18:32:00 | 694
A | Tuesday | 18:33:00 | 18:33:00 | 783
A | Tuesday | 18:34:00 | 18:34:00 | 353
A | Tuesday | 18:35:00 | 18:35:00 | 565
A | Tuesday | 18:36:00 | 18:36:00 | 129
A | Tuesday | 18:37:00 | 18:37:00 | 728
A | Tuesday | 18:38:00 | 18:38:00 | 455
A | Tuesday | 18:39:00 | 18:39:00 | 458
A | Tuesday | 18:40:00 | 18:40:00 | 916
A | Wednesday | 18:25:00 | 18:25:00 | 858
A | Wednesday | 18:26:00 | 18:26:00 | 418
A | Wednesday | 18:27:00 | 18:27:00 | 225
A | Wednesday | 18:28:00 | 18:28:00 | 721
A | Wednesday | 18:29:00 | 18:29:00 | 195
A | Wednesday | 18:30:00 | 18:30:00 | 646
A | Wednesday | 18:31:00 | 18:31:00 | 632
A | Wednesday | 18:32:00 | 18:32:00 | 431
A | Wednesday | 18:33:00 | 18:33:00 | 555
A | Wednesday | 18:34:00 | 18:34:00 | 669
A | Wednesday | 18:35:00 | 18:35:00 | 239
A | Wednesday | 18:36:00 | 18:36:00 | 836
A | Wednesday | 18:37:00 | 18:37:00 | 55
A | Wednesday | 18:38:00 | 18:38:00 | 963
A | Wednesday | 18:39:00 | 18:39:00 | 335
A | Wednesday | 18:40:00 | 18:40:00 | 105
A | Thursday | 18:25:00 | 18:25:00 | 508
A | Thursday | 18:26:00 | 18:26:00 | 905
A | Thursday | 18:27:00 | 18:27:00 | 355
A | Thursday | 18:28:00 | 18:28:00 | 182
A | Thursday | 18:29:00 | 18:29:00 | 837
A | Thursday | 18:30:00 | 18:30:00 | 734
A | Thursday | 18:31:00 | 18:31:00 | 269
A | Thursday | 18:32:00 | 18:32:00 | 487
A | Thursday | 18:33:00 | 18:33:00 | 452
A | Thursday | 18:34:00 | 18:34:00 | 844
A | Thursday | 18:35:00 | 18:35:00 | 588
A | Thursday | 18:36:00 | 18:36:00 | 937
A | Thursday | 18:37:00 | 18:37:00 | 328
A | Thursday | 18:38:00 | 18:38:00 | 951
A | Thursday | 18:39:00 | 18:39:00 | 972
A | Thursday | 18:40:00 | 18:40:00 | 216
A | Friday | 18:25:00 | 18:25:00 | 938
A | Friday | 18:26:00 | 18:26:00 | 629
A | Friday | 18:27:00 | 18:27:00 | 731
A | Friday | 18:28:00 | 18:28:00 | 773
A | Friday | 18:29:00 | 18:29:00 | 72
A | Friday | 18:30:00 | 18:30:00 | 361
A | Friday | 18:31:00 | 18:31:00 | 458
A | Friday | 18:32:00 | 18:32:00 | 101
A | Friday | 18:33:00 | 18:33:00 | 346
A | Friday | 18:34:00 | 18:34:00 | 247
A | Friday | 18:35:00 | 18:35:00 | 173
A | Friday | 18:36:00 | 18:36:00 | 232
A | Friday | 18:37:00 | 18:37:00 | 330
A | Friday | 18:38:00 | 18:38:00 | 575
A | Friday | 18:39:00 | 18:39:00 | 245
A | Friday | 18:40:00 | 18:40:00 | 697
A | Saturday | 18:25:00 | 18:25:00 | 952
A | Saturday | 18:26:00 | 18:26:00 | 764
A | Saturday | 18:27:00 | 18:27:00 | 658
A | Saturday | 18:28:00 | 18:28:00 | 771
A | Saturday | 18:29:00 | 18:29:00 | 538
A | Saturday | 18:30:00 | 18:30:00 | 996
A | Saturday | 18:31:00 | 18:31:00 | 526
A | Saturday | 18:32:00 | 18:32:00 | 735
A | Saturday | 18:33:00 | 18:33:00 | 287
A | Saturday | 18:34:00 | 18:34:00 | 947
A | Saturday | 18:35:00 | 18:35:00 | 100
A | Saturday | 18:36:00 | 18:36:00 | 706
A | Saturday | 18:37:00 | 18:37:00 | 905
A | Saturday | 18:38:00 | 18:38:00 | 844
A | Saturday | 18:39:00 | 18:39:00 | 607
A | Saturday | 18:40:00 | 18:40:00 | 572
A | Sunday | 18:25:00 | 18:25:00 | 260
A | Sunday | 18:26:00 | 18:26:00 | 951
A | Sunday | 18:27:00 | 18:27:00 | 85
A | Sunday | 18:28:00 | 18:28:00 | 745
A | Sunday | 18:29:00 | 18:29:00 | 542
A | Sunday | 18:30:00 | 18:30:00 | 989
A | Sunday | 18:31:00 | 18:31:00 | 603
A | Sunday | 18:32:00 | 18:32:00 | 970
A | Sunday | 18:33:00 | 18:33:00 | 897
A | Sunday | 18:34:00 | 18:34:00 | 490
A | Sunday | 18:35:00 | 18:35:00 | 178
A | Sunday | 18:36:00 | 18:36:00 | 392
A | Sunday | 18:37:00 | 18:37:00 | 728
A | Sunday | 18:38:00 | 18:38:00 | 409
A | Sunday | 18:39:00 | 18:39:00 | 615
A | Sunday | 18:40:00 | 18:40:00 | 343
B | Monday | 18:25:00 | 18:25:00 | 267
B | Monday | 18:26:00 | 18:26:00 | 307
B | Monday | 18:27:00 | 18:27:00 | 759
B | Monday | 18:28:00 | 18:28:00 | 732
B | Monday | 18:29:00 | 18:29:00 | 593
B | Monday | 18:30:00 | 18:30:00 | 527
B | Monday | 18:31:00 | 18:31:00 | 960
B | Monday | 18:32:00 | 18:32:00 | 968
B | Monday | 18:33:00 | 18:33:00 | 956
B | Monday | 18:34:00 | 18:34:00 | 110
B | Monday | 18:35:00 | 18:35:00 | 634
B | Monday | 18:36:00 | 18:36:00 | 805
B | Monday | 18:37:00 | 18:37:00 | 490
B | Monday | 18:38:00 | 18:38:00 | 548
B | Monday | 18:39:00 | 18:39:00 | 997
B | Monday | 18:40:00 | 18:40:00 | 756
B | Tuesday | 18:25:00 | 18:25:00 | 919
B | Tuesday | 18:26:00 | 18:26:00 | 791
B | Tuesday | 18:27:00 | 18:27:00 | 217
B | Tuesday | 18:28:00 | 18:28:00 | 490
B | Tuesday | 18:29:00 | 18:29:00 | 181
B | Tuesday | 18:30:00 | 18:30:00 | 440
B | Tuesday | 18:31:00 | 18:31:00 | 101
B | Tuesday | 18:32:00 | 18:32:00 | 705
B | Tuesday | 18:33:00 | 18:33:00 | 775
B | Tuesday | 18:34:00 | 18:34:00 | 335
B | Tuesday | 18:35:00 | 18:35:00 | 814
B | Tuesday | 18:36:00 | 18:36:00 | 319
B | Tuesday | 18:37:00 | 18:37:00 | 80
B | Tuesday | 18:38:00 | 18:38:00 | 525
B | Tuesday | 18:39:00 | 18:39:00 | 216
B | Tuesday | 18:40:00 | 18:40:00 | 334
B | Wednesday | 18:25:00 | 18:25:00 | 307
B | Wednesday | 18:26:00 | 18:26:00 | 369
B | Wednesday | 18:27:00 | 18:27:00 | 191
B | Wednesday | 18:28:00 | 18:28:00 | 267
B | Wednesday | 18:29:00 | 18:29:00 | 796
B | Wednesday | 18:30:00 | 18:30:00 | 829
B | Wednesday | 18:31:00 | 18:31:00 | 973
B | Wednesday | 18:32:00 | 18:32:00 | 797
B | Wednesday | 18:33:00 | 18:33:00 | 610
B | Wednesday | 18:34:00 | 18:34:00 | 653
B | Wednesday | 18:35:00 | 18:35:00 | 176
B | Wednesday | 18:36:00 | 18:36:00 | 877
B | Wednesday | 18:37:00 | 18:37:00 | 893
B | Wednesday | 18:38:00 | 18:38:00 | 562
B | Wednesday | 18:39:00 | 18:39:00 | 490
B | Wednesday | 18:40:00 | 18:40:00 | 315
B | Thursday | 18:25:00 | 18:25:00 | 647
B | Thursday | 18:26:00 | 18:26:00 | 969
B | Thursday | 18:27:00 | 18:27:00 | 605
B | Thursday | 18:28:00 | 18:28:00 | 101
B | Thursday | 18:29:00 | 18:29:00 | 885
B | Thursday | 18:30:00 | 18:30:00 | 570
B | Thursday | 18:31:00 | 18:31:00 | 51
B | Thursday | 18:32:00 | 18:32:00 | 762
B | Thursday | 18:33:00 | 18:33:00 | 804
B | Thursday | 18:34:00 | 18:34:00 | 479
B | Thursday | 18:35:00 | 18:35:00 | 508
B | Thursday | 18:36:00 | 18:36:00 | 491
B | Thursday | 18:37:00 | 18:37:00 | 843
B | Thursday | 18:38:00 | 18:38:00 | 433
B | Thursday | 18:39:00 | 18:39:00 | 852
B | Thursday | 18:40:00 | 18:40:00 | 764
B | Friday | 18:25:00 | 18:25:00 | 144
B | Friday | 18:26:00 | 18:26:00 | 98
B | Friday | 18:27:00 | 18:27:00 | 195
B | Friday | 18:28:00 | 18:28:00 | 119
B | Friday | 18:29:00 | 18:29:00 | 755
B | Friday | 18:30:00 | 18:30:00 | 156
B | Friday | 18:31:00 | 18:31:00 | 726
B | Friday | 18:32:00 | 18:32:00 | 464
B | Friday | 18:33:00 | 18:33:00 | 373
B | Friday | 18:34:00 | 18:34:00 | 966
B | Friday | 18:35:00 | 18:35:00 | 681
B | Friday | 18:36:00 | 18:36:00 | 647
B | Friday | 18:37:00 | 18:37:00 | 204
B | Friday | 18:38:00 | 18:38:00 | 642
B | Friday | 18:39:00 | 18:39:00 | 896
B | Friday | 18:40:00 | 18:40:00 | 692
B | Saturday | 18:25:00 | 18:25:00 | 76
B | Saturday | 18:26:00 | 18:26:00 | 905
B | Saturday | 18:27:00 | 18:27:00 | 165
B | Saturday | 18:28:00 | 18:28:00 | 606
B | Saturday | 18:29:00 | 18:29:00 | 433
B | Saturday | 18:30:00 | 18:30:00 | 143
B | Saturday | 18:31:00 | 18:31:00 | 551
B | Saturday | 18:32:00 | 18:32:00 | 528
B | Saturday | 18:33:00 | 18:33:00 | 206
B | Saturday | 18:34:00 | 18:34:00 | 598
B | Saturday | 18:35:00 | 18:35:00 | 425
B | Saturday | 18:36:00 | 18:36:00 | 854
B | Saturday | 18:37:00 | 18:37:00 | 131
B | Saturday | 18:38:00 | 18:38:00 | 558
B | Saturday | 18:39:00 | 18:39:00 | 640
B | Saturday | 18:40:00 | 18:40:00 | 814
B | Sunday | 18:25:00 | 18:25:00 | 489
B | Sunday | 18:26:00 | 18:26:00 | 795
B | Sunday | 18:27:00 | 18:27:00 | 257
B | Sunday | 18:28:00 | 18:28:00 | 477
B | Sunday | 18:29:00 | 18:29:00 | 857
B | Sunday | 18:30:00 | 18:30:00 | 126
B | Sunday | 18:31:00 | 18:31:00 | 925
B | Sunday | 18:32:00 | 18:32:00 | 503
B | Sunday | 18:33:00 | 18:33:00 | 865
B | Sunday | 18:34:00 | 18:34:00 | 312
B | Sunday | 18:35:00 | 18:35:00 | 708
B | Sunday | 18:36:00 | 18:36:00 | 383
B | Sunday | 18:37:00 | 18:37:00 | 650
B | Sunday | 18:38:00 | 18:38:00 | 653
B | Sunday | 18:39:00 | 18:39:00 | 731
B | Sunday | 18:40:00 | 18:40:00 | 995
C | Monday | 18:25:00 | 18:25:00 | 489
C | Monday | 18:26:00 | 18:26:00 | 60
C | Monday | 18:27:00 | 18:27:00 | 704
C | Monday | 18:28:00 | 18:28:00 | 160
C | Monday | 18:29:00 | 18:29:00 | 124
C | Monday | 18:30:00 | 18:30:00 | 185
C | Monday | 18:31:00 | 18:31:00 | 436
C | Monday | 18:32:00 | 18:32:00 | 492
C | Monday | 18:33:00 | 18:33:00 | 387
C | Monday | 18:34:00 | 18:34:00 | 520
C | Monday | 18:35:00 | 18:35:00 | 842
C | Monday | 18:36:00 | 18:36:00 | 75
C | Monday | 18:37:00 | 18:37:00 | 523
C | Monday | 18:38:00 | 18:38:00 | 636
C | Monday | 18:39:00 | 18:39:00 | 109
C | Monday | 18:40:00 | 18:40:00 | 537
C | Tuesday | 18:25:00 | 18:25:00 | 760
C | Tuesday | 18:26:00 | 18:26:00 | 896
C | Tuesday | 18:27:00 | 18:27:00 | 891
C | Tuesday | 18:28:00 | 18:28:00 | 717
C | Tuesday | 18:29:00 | 18:29:00 | 122
C | Tuesday | 18:30:00 | 18:30:00 | 964
C | Tuesday | 18:31:00 | 18:31:00 | 286
C | Tuesday | 18:32:00 | 18:32:00 | 728
C | Tuesday | 18:33:00 | 18:33:00 | 385
C | Tuesday | 18:34:00 | 18:34:00 | 67
C | Tuesday | 18:35:00 | 18:35:00 | 236
C | Tuesday | 18:36:00 | 18:36:00 | 429
C | Tuesday | 18:37:00 | 18:37:00 | 720
C | Tuesday | 18:38:00 | 18:38:00 | 344
C | Tuesday | 18:39:00 | 18:39:00 | 198
C | Tuesday | 18:40:00 | 18:40:00 | 595
C | Wednesday | 18:25:00 | 18:25:00 | 64
C | Wednesday | 18:26:00 | 18:26:00 | 601
C | Wednesday | 18:27:00 | 18:27:00 | 699
C | Wednesday | 18:28:00 | 18:28:00 | 305
C | Wednesday | 18:29:00 | 18:29:00 | 118
C | Wednesday | 18:30:00 | 18:30:00 | 88
C | Wednesday | 18:31:00 | 18:31:00 | 929
C | Wednesday | 18:32:00 | 18:32:00 | 899
C | Wednesday | 18:33:00 | 18:33:00 | 101
C | Wednesday | 18:34:00 | 18:34:00 | 730
C | Wednesday | 18:35:00 | 18:35:00 | 300
C | Wednesday | 18:36:00 | 18:36:00 | 199
C | Wednesday | 18:37:00 | 18:37:00 | 80
C | Wednesday | 18:38:00 | 18:38:00 | 597
C | Wednesday | 18:39:00 | 18:39:00 | 682
C | Wednesday | 18:40:00 | 18:40:00 | 778
C | Thursday | 18:25:00 | 18:25:00 | 576
C | Thursday | 18:26:00 | 18:26:00 | 631
C | Thursday | 18:27:00 | 18:27:00 | 999
C | Thursday | 18:28:00 | 18:28:00 | 455
C | Thursday | 18:29:00 | 18:29:00 | 859
C | Thursday | 18:30:00 | 18:30:00 | 242
C | Thursday | 18:31:00 | 18:31:00 | 696
C | Thursday | 18:32:00 | 18:32:00 | 546
C | Thursday | 18:33:00 | 18:33:00 | 359
C | Thursday | 18:34:00 | 18:34:00 | 732
C | Thursday | 18:35:00 | 18:35:00 | 841
C | Thursday | 18:36:00 | 18:36:00 | 744
C | Thursday | 18:37:00 | 18:37:00 | 858
C | Thursday | 18:38:00 | 18:38:00 | 432
C | Thursday | 18:39:00 | 18:39:00 | 255
C | Thursday | 18:40:00 | 18:40:00 | 58
C | Friday | 18:25:00 | 18:25:00 | 454
C | Friday | 18:26:00 | 18:26:00 | 268
C | Friday | 18:27:00 | 18:27:00 | 566
C | Friday | 18:28:00 | 18:28:00 | 416
C | Friday | 18:29:00 | 18:29:00 | 643
C | Friday | 18:30:00 | 18:30:00 | 275
C | Friday | 18:31:00 | 18:31:00 | 457
C | Friday | 18:32:00 | 18:32:00 | 619
C | Friday | 18:33:00 | 18:33:00 | 940
C | Friday | 18:34:00 | 18:34:00 | 530
C | Friday | 18:35:00 | 18:35:00 | 113
C | Friday | 18:36:00 | 18:36:00 | 341
C | Friday | 18:37:00 | 18:37:00 | 163
C | Friday | 18:38:00 | 18:38:00 | 621
C | Friday | 18:39:00 | 18:39:00 | 997
C | Friday | 18:40:00 | 18:40:00 | 303
C | Saturday | 18:25:00 | 18:25:00 | 951
C | Saturday | 18:26:00 | 18:26:00 | 430
C | Saturday | 18:27:00 | 18:27:00 | 501
C | Saturday | 18:28:00 | 18:28:00 | 627
C | Saturday | 18:29:00 | 18:29:00 | 973
C | Saturday | 18:30:00 | 18:30:00 | 303
C | Saturday | 18:31:00 | 18:31:00 | 120
C | Saturday | 18:32:00 | 18:32:00 | 976
C | Saturday | 18:33:00 | 18:33:00 | 848
C | Saturday | 18:34:00 | 18:34:00 | 822
C | Saturday | 18:35:00 | 18:35:00 | 302
C | Saturday | 18:36:00 | 18:36:00 | 364
C | Saturday | 18:37:00 | 18:37:00 | 434
C | Saturday | 18:38:00 | 18:38:00 | 249
C | Saturday | 18:39:00 | 18:39:00 | 592
C | Saturday | 18:40:00 | 18:40:00 | 139
C | Sunday | 18:25:00 | 18:25:00 | 430
C | Sunday | 18:26:00 | 18:26:00 | 488
C | Sunday | 18:27:00 | 18:27:00 | 318
C | Sunday | 18:28:00 | 18:28:00 | 595
C | Sunday | 18:29:00 | 18:29:00 | 698
C | Sunday | 18:30:00 | 18:30:00 | 455
C | Sunday | 18:31:00 | 18:31:00 | 568
C | Sunday | 18:32:00 | 18:32:00 | 988
C | Sunday | 18:33:00 | 18:33:00 | 310
C | Sunday | 18:34:00 | 18:34:00 | 590
C | Sunday | 18:35:00 | 18:35:00 | 999
C | Sunday | 18:36:00 | 18:36:00 | 907
C | Sunday | 18:37:00 | 18:37:00 | 688
C | Sunday | 18:38:00 | 18:38:00 | 516
C | Sunday | 18:39:00 | 18:39:00 | 475
C | Sunday | 18:40:00 | 18:40:00 | 588