Spreadsheet: 861855d1709684111-xlookup-value-a-column-over-the-first-find-xlookup-test
Sheet: Sheet1

 | 11/1/2023 |  |  |  |  |  |  | 12/1/2023 |  |  |  |  |  |  | 1/1/2024
 | Success | Maintenance | Total |  | Success | Maintenance |  | Success | Maintenance | Total |  | Success | Maintenance |  | Success | Maintenance | Total |  | Success | Maintenance
a | 1226811.59420521 | 74451.91586561296 | 1301263.510070823 |  | 0.9427849046027882 | 0.05721509539721192 |  | 1559864.121024276 | 257149.4501155631 | 1817013.571139839 |  | 0.905744755660679 | 0.094255244339321 |  | 713394.7856539545 | 72847.40894868283 | 786242.1946026373 |  | 0.9073473677083694 | 0.09265263229163061
b | 417557.7346223901 | 113824.1486166428 | 531381.8832390328 |  | 0.7857959554006079 | 0.2142040445993921 |  | 383282.7950143373 | 110909.2611112329 | 494192.0561255703 |  | 0.7755745772589842 | 0.2244254227410159 |  | 272108.8971324975 | 30301.45796886637 | 302410.3551013638 |  | 0.8998001971238394 | 0.1001998028761605
c | 222556.8335207845 | 22080.45776661636 | 244637.2912874008 |  | 0.9097420607855073 | 0.09025793921449267 |  | 122020.9487142291 | 22764.78568638393 | 144785.734400613 |  | 0.8427691389581573 | 0.1572308610418427 |  | 139098.5563721199 | 74273.05149692003 | 213371.6078690399 |  | 0.6519075230360253 | 0.3480924769639747
d | 32513.9527409088 | 181770.8605872331 | 214284.8133281419 |  | 0.1517324174117698 | 0.8482675825882302 |  | 0 | 404259.6358917485 | 404259.6358917485 |  | 0 | 1 |  | 0 | 321213.5234498233 | 321213.5234498233 |  | 0 | 1
e | 0 | 13205.45459100907 | 13205.45459100907 |  | 0 | 1 |  | 0 | 21288.09789387251 | 21288.09789387251 |  | 0 | 1 |  | 0 | 0 | 0 |  | 0 | 0
f | 57572.6099938158 | 48236.55861732549 | 105809.1686111413 |  | 0.5441174025797386 | 0.4558825974202614 |  | 184012.3256232867 | 191610.149919569 | 375622.4755428557 |  | 0.4898863555950668 | 0.5101136444049332 |  | 231683.7880014686 | 1082485.46 | 1314169.248001469 |  | 0.1762967656972671 | 0.8237032343027328
g | 757570.2204623019 | 206509.8505226446 | 964080.0709849466 |  | 0.7857959554006079 | 0.2142040445993921 |  | 671715.9334712424 | 194372.194178846 | 866088.1276500884 |  | 0.7755745772589842 | 0.2244254227410159 |  | 945012.0521317029 | 105234.4972160085 | 1050246.549347711 |  | 0.8998001971238394 | 0.1001998028761605
h | 199899.6391416728 | 167483.6465130774 | 367383.2856547502 |  | 0.5441174025797386 | 0.4558825974202615 |  | 144798.5618888657 | 150777.2593911093 | 295575.821279975 |  | 0.4898863555950668 | 0.5101136444049332 |  | 93232.07367073075 | 435603.9109373295 | 528835.9846080602 |  | 0.1762967656972671 | 0.8237032343027328
Total | 2914482.584687084 | 827562.8930801618 | 3742045.477767245 |  | 0.778847451748785 | 0.2211525482512151 |  | 3065694.685736237 | 1353130.834188325 | 4418825.519924562 |  | 0.6494959791847751 | 0.3505040208152249 |  | 2394530.152962475 | 2121959.31001763 | 4516489.462980105 |  | 0.5301750779204735 | 0.4698249220795266
 |  |  |  | lookup | success | maintenance
date | 1/1/2024 |  |  | a |  |  | <--- trying to find this value which is in cell  q3 by just using the xlookup function
column marker | ColMark |  | 30301.45796886637 | b |  |  | by using the xlookup to find "a" row and the 1/1/2024 date I can get the answer in cell p3, but I need q3 in column 17
 |  |  | 74273.05149692003 | c
 |  |  | 321213.5234498233 | d
 |  |  | 0 | e
 |  |  | 1082485.46 | f
 |  |  | 105234.4972160085 | g
 |  |  | 435603.9109373295 | h