Spreadsheet: 865791d1712768904-can-i-use-exact-or-isnumber-search-to-look-for-more-than-one-thing-example
Sheet: Sheet1

Date | Test | Color | Result |  |  |  | Blue |  |  |  |  | Green |  |  |  |  | Shades of Blue
2024-01-01 00:00:00 | 1 | Blue | 45 |  |  |  | Date | Test | Color | Result |  | Date | Test | Color | Result |  | Date | Test | Color | Result
2024-01-02 00:00:00 | 2 | Green | 45 |  |  |  |  | 1 | Blue | 45 |  |  | 2 | Green | 45 |  | 2024-01-01 00:00:00 | 1 | Blue | 45
2024-01-03 00:00:00 | 3 | White | 43 |  |  |  | 2024-01-06 00:00:00 | 6 | Blue | 31 |  | 45298 | 7 | Green | 35 |  | 2024-01-04 00:00:00 | 4 | Light Blue | 345 | This is what I want the formula to do so that once the source table is updated,  all the data is classified accordingly.
2024-01-04 00:00:00 | 4 | Light Blue | 345 |  |  |  | 2024-01-11 00:00:00 | 11 | Blue | 49.3809523809524 |  | 45303 | 12 | Green | 44.7857142857143 |  | 2024-01-05 00:00:00 | 5 | [NAME] | 45
2024-01-05 00:00:00 | 5 | [NAME] | 45 |  |  |  | 2024-01-16 00:00:00 | 16 | Blue | 26.4047619047619 |  | 45308 | 17 | Green | 21.8095238095238 |  | 2024-01-06 00:00:00 | 6 | Blue | 31
2024-01-06 00:00:00 | 6 | Blue | 31 |  |  |  | 2024-01-21 00:00:00 | 21 | Blue | 3.42857142857143 |  | 45313 | 22 | Green | -1.16666666666667 |  | 2024-01-09 00:00:00 | 9 | Light Blue | 58.5714285714285
2024-01-07 00:00:00 | 7 | Green | 35 |  |  |  | 2024-01-26 00:00:00 | 26 | Blue | -19.5476190476187 |  | 45318 | 27 | Green | -24.1428571428567 |  | 2024-01-10 00:00:00 | 10 | [NAME] | 53.9761904761905
2024-01-08 00:00:00 | 8 | White | 45 |  |  |  | 2024-01-31 00:00:00 | 31 | Blue | -42.5238095238097 |  | 45323 | 32 | Green | -47.1190476190477 |  | 2024-01-11 00:00:00 | 11 | Blue | 49.3809523809524
2024-01-09 00:00:00 | 9 | Light Blue | 58.5714285714285 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-14 00:00:00 | 14 | Light Blue | 35.5952380952381
2024-01-10 00:00:00 | 10 | [NAME] | 53.9761904761905 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-15 00:00:00 | 15 | [NAME] | 31
2024-01-11 00:00:00 | 11 | Blue | 49.3809523809524 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-16 00:00:00 | 16 | Blue | 26.4047619047619
2024-01-12 00:00:00 | 12 | Green | 44.7857142857143 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00 | 19 | Light Blue | 12.6190476190476
2024-01-13 00:00:00 | 13 | White | 40.1904761904762 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-20 00:00:00 | 20 | [NAME] | 8.02380952380953
2024-01-14 00:00:00 | 14 | Light Blue | 35.5952380952381 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-21 00:00:00 | 21 | Blue | 3.42857142857143
2024-01-15 00:00:00 | 15 | [NAME] | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-24 00:00:00 | 24 | Light Blue | -10.3571428571427
2024-01-16 00:00:00 | 16 | Blue | 26.4047619047619 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-25 00:00:00 | 25 | [NAME] | -14.9523809523807
2024-01-17 00:00:00 | 17 | Green | 21.8095238095238 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-26 00:00:00 | 26 | Blue | -19.5476190476187
2024-01-18 00:00:00 | 18 | White | 17.2142857142857 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-29 00:00:00 | 29 | Light Blue | -33.3333333333337
2024-01-19 00:00:00 | 19 | Light Blue | 12.6190476190476 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-30 00:00:00 | 30 | [NAME] | -37.9285714285717
2024-01-20 00:00:00 | 20 | [NAME] | 8.02380952380953 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-31 00:00:00 | 31 | Blue | -42.5238095238097
2024-01-21 00:00:00 | 21 | Blue | 3.42857142857143
2024-01-22 00:00:00 | 22 | Green | -1.16666666666667
2024-01-23 00:00:00 | 23 | White | -5.76190476190467
2024-01-24 00:00:00 | 24 | Light Blue | -10.3571428571427
2024-01-25 00:00:00 | 25 | [NAME] | -14.9523809523807
2024-01-26 00:00:00 | 26 | Blue | -19.5476190476187
2024-01-27 00:00:00 | 27 | Green | -24.1428571428567
2024-01-28 00:00:00 | 28 | White | -28.7380952380957
2024-01-29 00:00:00 | 29 | Light Blue | -33.3333333333337
2024-01-30 00:00:00 | 30 | [NAME] | -37.9285714285717
2024-01-31 00:00:00 | 31 | Blue | -42.5238095238097
2024-02-01 00:00:00 | 32 | Green | -47.1190476190477