Spreadsheet: 771648d1646770216-vlookup-for-multiple-criteria-using-multiple-table-arrays-sample-data
Sheet: Test

Pricing Date | Year | Benchmark | YLD | SPRD
2022-03-02 10:56:00 | 2028 |  | 1.52
2022-03-02 10:56:00 | 2029 |  | 1.59
2022-03-02 10:56:00 | 2030 |  | 1.68
2022-03-02 10:56:00 | 2031 |  | 1.73
2022-03-02 10:56:00 | 2033 |  | 1.85
2022-03-02 10:56:00 | 2034 |  | 1.94
2022-03-02 10:56:00 | 2039 |  | 2.21
2022-03-02 10:56:00 | 2039 |  | 2.41
2022-03-02 10:56:00 | 2045 |  | 3
2022-03-02 10:56:00 | 2045 |  | 2.24
2022-03-02 10:56:00 | 2045 |  | 2.56
2022-03-02 10:56:00 | 2045 |  | 2.36
2022-03-02 19:30:00 | 2029 |  | 3.158
2022-03-02 19:30:00 | 2030 |  | 3.258
2022-03-02 19:30:00 | 2031 |  | 3.358
2022-03-02 19:30:00 | 2032 |  | 3.408
2022-03-02 19:30:00 | 2033 |  | 3.608
2022-03-02 19:30:00 | 2034 |  | 3.758
2022-03-02 19:30:00 | 2035 |  | 3.858
2022-03-02 19:30:00 | 2036 |  | 3.958
2022-03-02 19:30:00 | 2037 |  | 4.058
2022-03-02 19:30:00 | 2048 |  | 4.242
2022-03-01 16:42:00 | 2052 |  | 3.067
2022-03-02 17:00:00 | 2022 |  | 4.165
2022-03-02 13:56:00 | 2023 |  | 0.9
2022-03-02 13:56:00 | 2024 |  | 1.11
2022-03-02 13:56:00 | 2025 |  | 1.24
2022-03-02 13:56:00 | 2026 |  | 1.34
2022-03-02 13:56:00 | 2027 |  | 1.41
2022-03-02 13:56:00 | 2028 |  | 1.49
2022-03-02 13:56:00 | 2029 |  | 1.54
2022-03-02 13:56:00 | 2030 |  | 1.57
2022-03-02 13:56:00 | 2031 |  | 1.6
2022-03-02 13:56:00 | 2032 |  | 1.7
2022-03-02 13:56:00 | 2033 |  | 1.87
2022-03-02 13:56:00 | 2034 |  | 1.92
2022-03-02 13:56:00 | 2035 |  | 1.97
2022-03-02 13:56:00 | 2036 |  | 2
2022-03-02 13:56:00 | 2037 |  | 2.05
2022-03-02 13:56:00 | 2042 |  | 2.72
2022-03-02 13:56:00 | 2046 |  | 2.87
2022-03-03 09:45:00 | 2023 |  | 0.81
2022-03-03 09:45:00 | 2024 |  | 1.06
2022-03-03 09:45:00 | 2025 |  | 1.17
2022-03-03 09:45:00 | 2026 |  | 1.26
2022-03-03 09:45:00 | 2027 |  | 1.32
2022-03-03 09:45:00 | 2028 |  | 1.41
2022-03-03 09:45:00 | 2029 |  | 1.48
2022-03-03 09:45:00 | 2030 |  | 1.51
2022-03-03 09:45:00 | 2031 |  | 1.54
2022-03-03 09:45:00 | 2032 |  | 1.57
2022-03-03 09:45:00 | 2033 |  | 1.64
2022-03-03 09:45:00 | 2034 |  | 1.66
2022-03-03 09:45:00 | 2035 |  | 1.69
2022-03-03 09:45:00 | 2036 |  | 1.71
2022-03-03 09:45:00 | 2037 |  | 1.73
2022-03-03 09:45:00 | 2038 |  | 1.99
2022-03-03 09:45:00 | 2039 |  | 2.01
2022-03-03 09:45:00 | 2040 |  | 2.03
2022-03-03 09:45:00 | 2041 |  | 2.05
2022-03-03 09:45:00 | 2042 |  | 2.07
2022-03-02 21:34:00 | 2028 |  | 2.241
2022-03-02 21:34:00 | 2029 |  | 2.381
2022-03-02 21:34:00 | 2030 |  | 2.444
2022-03-02 21:34:00 | 2031 |  | 2.544
2022-03-02 21:34:00 | 2032 |  | 2.614
2022-03-02 21:34:00 | 2037 |  | 3.094
2022-03-01 15:07:00 | 2022 |  | 0.7
2022-03-01 15:07:00 | 2023 |  | 1
2022-03-01 15:07:00 | 2024 |  | 1.23
2022-03-01 15:07:00 | 2025 |  | 1.37
2022-03-01 15:07:00 | 2026 |  | 1.5
2022-03-01 15:07:00 | 2027 |  | 1.6
2022-03-01 15:07:00 | 2028 |  | 1.7
2022-03-01 15:07:00 | 2029 |  | 2
2022-03-01 15:07:00 | 2030 |  | 2.1
2022-03-01 15:07:00 | 2031 |  | 2.2
2022-03-01 15:07:00 | 2032 |  | 2.3
2022-03-01 15:07:00 | 2033 |  | 2.35
2022-03-01 15:07:00 | 2034 |  | 2.4
2022-03-01 15:07:00 | 2035 |  | 2.47
2022-03-01 15:07:00 | 2036 |  | 2.6
2022-03-01 15:07:00 | 2037 |  | 2.65
2022-03-01 15:07:00 | 2038 |  | 2.7
2022-03-01 15:07:00 | 2039 |  | 2.75
2022-03-01 15:07:00 | 2043 |  | 3
2022-03-01 15:07:00 | 2047 |  | 3.05
2022-03-01 15:07:00 | 2051 |  | 3.1
2022-03-02 18:38:00 | 2022 |  | 0.92
2022-03-02 18:38:00 | 2023 |  | 1.1
2022-03-02 18:38:00 | 2024 |  | 1.33
2022-03-02 18:38:00 | 2025 |  | 1.48
2022-03-02 18:38:00 | 2026 |  | 1.57
2022-03-02 18:38:00 | 2027 |  | 1.67
2022-03-02 18:38:00 | 2028 |  | 1.77
2022-03-02 18:38:00 | 2029 |  | 1.84
2022-03-02 18:38:00 | 2030 |  | 1.89
2022-03-02 18:38:00 | 2031 |  | 1.94
2022-03-02 18:38:00 | 2032 |  | 1.96
2022-03-02 18:38:00 | 2033 |  | 2.03
2022-03-02 18:38:00 | 2034 |  | 2.06
2022-03-02 18:38:00 | 2035 |  | 2.22
2022-03-02 18:38:00 | 2036 |  | 2.24
2022-03-02 18:38:00 | 2037 |  | 2.27
2022-03-02 18:38:00 | 2038 |  | 2.3
2022-03-02 18:38:00 | 2039 |  | 2.32
2022-03-02 18:38:00 | 2040 |  | 2.34
2022-03-02 18:38:00 | 2041 |  | 2.36
2022-03-02 18:38:00 | 2042 |  | 2.38
2022-03-02 18:38:00 | 2047 |  | 2.51
2022-03-02 18:38:00 | 2048 |  | 3.08
2022-03-02 18:38:00 | 2052 |  | 3.11
2022-03-02 18:38:00 | 2052 |  | 2.6
2022-02-28 21:02:00 | 2024 |  | 0.83
2022-02-28 21:02:00 | 2027 |  | 1.1
2022-02-28 21:02:00 | 2028 |  | 1.63
2022-03-01 14:58:00 | 2022 |  | 1.91
2022-03-01 14:58:00 | 2023 |  | 1.97
2022-03-01 14:58:00 | 2024 |  | 0.9
2022-03-01 14:58:00 | 2025 |  | 1
2022-03-01 14:58:00 | 2026 |  | 1.17
2022-03-01 14:58:00 | 2027 |  | 1.28
2022-03-01 14:58:00 | 2028 |  | 1.35
2022-03-01 14:58:00 | 2029 |  | 1.45
2022-03-01 14:58:00 | 2030 |  | 1.54
2022-03-01 14:58:00 | 2031 |  | 1.6
2022-03-01 14:58:00 | 2032 |  | 1.64
2022-03-01 14:58:00 | 2033 |  | 1.7
2022-03-01 14:58:00 | 2034 |  | 1.72
2022-03-01 14:58:00 | 2035 |  | 1.8
2022-03-01 14:58:00 | 2036 |  | 1.83
2022-03-01 14:58:00 | 2037 |  | 1.95
2022-03-01 14:58:00 | 2038 |  | 2.32
2022-03-01 14:58:00 | 2039 |  | 2.35
2022-03-01 14:58:00 | 2040 |  | 2.39
2022-03-01 14:58:00 | 2041 |  | 2.41
2022-03-01 14:58:00 | 2042 |  | 2.43
2022-02-28 20:59:00 | 2022 |  | 2.45
2022-02-28 20:59:00 | 2022 |  | 2.47
2022-02-28 20:59:00 | 2023 |  | 1.486
2022-02-28 20:59:00 | 2023 |  | 1.486
2022-02-28 20:59:00 | 2024 |  | 1.636
2022-02-28 20:59:00 | 2024 |  | 1.636
2022-02-28 20:59:00 | 2025 |  | 1.786
2022-02-28 20:59:00 | 2025 |  | 1.786
2022-02-28 20:59:00 | 2026 |  | 2.036
2022-02-28 20:59:00 | 2026 |  | 2.036
2022-02-28 20:59:00 | 2027 |  | 2.139
2022-02-28 20:59:00 | 2027 |  | 2.139
2022-02-28 20:59:00 | 2027 |  | 2.039
2022-02-28 20:59:00 | 2027 |  | 2.039
2022-02-28 20:59:00 | 2028 |  | 2.189
2022-02-28 20:59:00 | 2028 |  | 2.189
2022-02-28 20:59:00 | 2029 |  | 2.117
2022-02-28 20:59:00 | 2029 |  | 2.117
2022-02-28 20:59:00 | 2030 |  | 2.217
2022-02-28 20:59:00 | 2030 |  | 2.217
2022-02-28 20:59:00 | 2031 |  | 2.33
2022-02-28 20:59:00 | 2031 |  | 2.33
2022-02-28 20:59:00 | 2032 |  | 2.43
2022-02-28 20:59:00 | 2032 |  | 2.43
2022-02-28 20:59:00 | 2033 |  | 2.48
2022-02-28 20:59:00 | 2033 |  | 2.48
2022-02-28 20:59:00 | 2034 |  | 2.53
2022-02-28 20:59:00 | 2034 |  | 2.53
2022-02-28 20:59:00 | 2035 |  | 2.68
2022-02-28 20:59:00 | 2035 |  | 2.68
2022-02-28 20:59:00 | 2036 |  | 2.78
2022-02-28 20:59:00 | 2036 |  | 2.78
2022-02-28 20:59:00 | 2037 |  | 2.83
2022-02-28 20:59:00 | 2037 |  | 2.83
2022-02-28 20:59:00 | 2038 |  | 2.93
2022-02-28 20:59:00 | 2038 |  | 2.93
2022-02-28 20:59:00 | 2039 |  | 3.03
2022-02-28 20:59:00 | 2039 |  | 3.03
2022-02-28 20:59:00 | 2040 |  | 3.08
 |  |  | 3.08
 |  |  | 3.18
 |  |  | 3.18
 |  |  | 3.381
 |  |  | 3.381
 |  |  | 0.87
 |  |  | 1.12
 |  |  | 1.22
 |  |  | 1.32
 |  |  | 1.39
 |  |  | 1.47
 |  |  | 1.55
 |  |  | 1.6
 |  |  | 1.65
 |  |  | 1.7
 |  |  | 0.97
 |  |  | 1.23
 |  |  | 1.34
 |  |  | 1.5
 |  |  | 1.56
 |  |  | 1.64
 |  |  | 1.76
 |  |  | 1.78
 |  |  | 1.79
 |  |  | 1.8
 |  |  | 1.97
 |  |  | 2.05
 |  |  | 2.1
 |  |  | 2.2
 |  |  | 2.62
 |  |  | 2.64
 |  |  | 2.66
 |  |  | 2.68
 |  |  | 2.7
 |  |  | 2.72
 |  |  | 2.75
 |  |  | 2.78
 |  |  | 0.95
 |  |  | 0.95
 |  |  | 1.15
 |  |  | 1.15
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.55
 |  |  | 1.55
 |  |  | 1.65
 |  |  | 1.65
 |  |  | 1.8
 |  |  | 1.8
 |  |  | 1.9
 |  |  | 1.9
 |  |  | 2
 |  |  | 2
 |  |  | 1.7
 |  |  | 1.7
 |  |  | 2.15
 |  |  | 2.15
 |  |  | 1.75
 |  |  | 1.75
 |  |  | 1.85
 |  |  | 1.85
 |  |  | 1.9
 |  |  | 1.9
 |  |  | 1.95
 |  |  | 1.95
 |  |  | 2.05
 |  |  | 2.05
 |  |  | 2.2
 |  |  | 2.2
 |  |  | 2.2
 |  |  | 2.2
 |  |  | 2.25
 |  |  | 2.25
 |  |  | 2.5
 |  |  | 2.5
 |  |  | 2.55
 |  |  | 2.55
 |  |  | 2.65
 |  |  | 2.65
 |  |  | 2.7
 |  |  | 2.7
 |  |  | 2.75
 |  |  | 2.75
 |  |  | 2.75
 |  |  | 2.75
 |  |  | 2.8
 |  |  | 2.8
 |  |  | 2.8
 |  |  | 2.8
 |  |  | 2.95
 |  |  | 2.95
 |  |  | 2.1
 |  |  | 2.1
 |  |  | 1.52
 |  |  | 1.74
 |  |  | 1.91
 |  |  | 2.03
 |  |  | 2.18
 |  |  | 2.346
 |  |  | 2.478
 |  |  | 2.578
 |  |  | 2.67
 |  |  | 2.77
 |  |  | 2.856
 |  |  | 0.78
 |  |  | 1.03
 |  |  | 1.12
 |  |  | 1.21
 |  |  | 1.27
 |  |  | 1.34
 |  |  | 1.41
 |  |  | 1.44
 |  |  | 1.47
 |  |  | 1.5
 |  |  | 1.6
 |  |  | 1.9
 |  |  | 2.32
 |  |  | 2.37
 |  |  | 2.42
 |  |  | 2.45
 |  |  | 2.48
 |  |  | 2.51
 |  |  | 2.54
 |  |  | 2.56
 |  |  | 1.05
 |  |  | 1.07
 |  |  | 1.25
 |  |  | 1.35
 |  |  | 1.41
 |  |  | 1.45
 |  |  | 1.52
 |  |  | 1.56
 |  |  | 1.6
 |  |  | 1.66
 |  |  | 1.7
 |  |  | 1.84
 |  |  | 1.86
 |  |  | 2.05
 |  |  | 2.11
 |  |  | 2.12
 |  |  | 2.17
 |  |  | 2.21
 |  |  | 2.23
 |  |  | 2.25
 |  |  | 2.27
 |  |  | 2.38
 |  |  | 2.48
 |  |  | 0.91
 |  |  | 0.91
 |  |  | 0.93
 |  |  | 0.93
 |  |  | 1.18
 |  |  | 1.18
 |  |  | 1.17
 |  |  | 1.17
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.29
 |  |  | 1.29
 |  |  | 1.39
 |  |  | 1.39
 |  |  | 1.38
 |  |  | 1.38
 |  |  | 1.48
 |  |  | 1.48
 |  |  | 1.48
 |  |  | 1.48
 |  |  | 1.57
 |  |  | 1.57
 |  |  | 1.56
 |  |  | 1.56
 |  |  | 1.66
 |  |  | 1.66
 |  |  | 1.65
 |  |  | 1.65
 |  |  | 1.7
 |  |  | 1.7
 |  |  | 1.72
 |  |  | 1.72
 |  |  | 1.75
 |  |  | 1.75
 |  |  | 1.78
 |  |  | 1.78
 |  |  | 1.79
 |  |  | 1.79
 |  |  | 1.8
 |  |  | 1.8
 |  |  | 1.86
 |  |  | 1.86
 |  |  | 1.89
 |  |  | 1.89
 |  |  | 2.01
 |  |  | 2.01
 |  |  | 1.91
 |  |  | 1.91
 |  |  | 2.05
 |  |  | 2.05
 |  |  | 1.93
 |  |  | 1.93
 |  |  | 2.1
 |  |  | 2.1
 |  |  | 1.95
 |  |  | 1.95
 |  |  | 2.15
 |  |  | 2.15
 |  |  | 1.97
 |  |  | 1.97
 |  |  | 2.17
 |  |  | 2.17
 |  |  | 2.2
 |  |  | 2.2
 |  |  | 2.19
 |  |  | 2.19
 |  |  | 2.22
 |  |  | 2.22
 |  |  | 2.21
 |  |  | 2.21
 |  |  | 2.24
 |  |  | 2.24
 |  |  | 2.24
 |  |  | 2.24
 |  |  | 2.72
 |  |  | 2.72
 |  |  | 2.27
 |  |  | 2.27
 |  |  | 2.07
 |  |  | 2.07
 |  |  | 2.44
 |  |  | 2.44
 |  |  | 2.55
 |  |  | 2.55
 |  |  | 0.85
 |  |  | 1.13
 |  |  | 1.28
 |  |  | 1.42
 |  |  | 1.51
 |  |  | 1.6
 |  |  | 1.7
 |  |  | 1.76
 |  |  | 1.83
 |  |  | 1.9
 |  |  | 2.04
 |  |  | 2.2
 |  |  | 2.35
 |  |  | 2.5
 |  |  | 2.62
 |  |  | 2.69
 |  |  | 2.76
 |  |  | 2.83
 |  |  | 2.9
 |  |  | 2.95
 |  |  | 3
 |  |  | 3.03
 |  |  | 3.06
 |  |  | 3.07
 |  |  | 3.08
 |  |  | 3.09
 |  |  | 3.1
 |  |  | 3.125
 |  |  | 3.14
 |  |  | 3.15
 |  |  | 1.41
 |  |  | 1.54
 |  |  | 1.64
 |  |  | 1.72
 |  |  | 1.8
 |  |  | 1.85
 |  |  | 1.91
 |  |  | 1.98
 |  |  | 2.1
 |  |  | 2.14
 |  |  | 2.19
 |  |  | 2.22
 |  |  | 2.27
 |  |  | 2.31
 |  |  | 2.48
 |  |  | 2.5
 |  |  | 2.52
 |  |  | 2.54
 |  |  | 2.68
 |  |  | 2.73
 |  |  | 0.86
 |  |  | 1.12
 |  |  | 1.22
 |  |  | 1.35
 |  |  | 1.42
 |  |  | 1.5
 |  |  | 1.54
 |  |  | 1.58
 |  |  | 1.65
 |  |  | 1.7
 |  |  | 1.8
 |  |  | 2.2
 |  |  | 2.3
 |  |  | 2.4
 |  |  | 2.5
 |  |  | 2.55
 |  |  | 2.6
 |  |  | 2.65
 |  |  | 2.7
 |  |  | 2.75
 |  |  | 2.8
 |  |  | 2.85
 |  |  | 3.02
 |  |  | 0.8
 |  |  | 0.93
 |  |  | 1.12
 |  |  | 1.26
 |  |  | 1.37
 |  |  | 1.44
 |  |  | 1.51
 |  |  | 1.56
 |  |  | 1.61
 |  |  | 1.65
 |  |  | 1.67
 |  |  | 1.73
 |  |  | 1.75
 |  |  | 2.01
 |  |  | 2.33
 |  |  | 2.37
 |  |  | 2.42
 |  |  | 2.44
 |  |  | 2.46
 |  |  | 2.48
 |  |  | 2.5
 |  |  | 0.8
 |  |  | 0.8
 |  |  | 0.95
 |  |  | 0.95
 |  |  | 1.18
 |  |  | 1.18
 |  |  | 1.31
 |  |  | 1.31
 |  |  | 1.4
 |  |  | 1.4
 |  |  | 1.49
 |  |  | 1.49
 |  |  | 1.59
 |  |  | 1.59
 |  |  | 1.56
 |  |  | 1.56
 |  |  | 1.64
 |  |  | 1.64
 |  |  | 1.7
 |  |  | 1.7
 |  |  | 1.74
 |  |  | 1.74
 |  |  | 1.8
 |  |  | 1.8
 |  |  | 1.88
 |  |  | 1.88
 |  |  | 1.92
 |  |  | 1.92
 |  |  | 1.94
 |  |  | 1.94
 |  |  | 1.98
 |  |  | 1.98