Spreadsheet: 99474d1298082138-lookup-or-match-formula-max-min-value-match2
Sheet: Match2

DATE | TIME | OPEN | HIGH | LOW | CLOSE |  | DATE | TIME | OPEN | HIGH | LOW | CLOSE
2001.01.03 | 05:00:00 | 0.9506 | 0.9507 | 0.9505 | 0.9505 |  | 2001.01.03 | 1900-01-01 00:00:00 | / | / | / | /
2001.01.03 | 06:00:00 | 0.9505 | 0.9513 | 0.9503 | 0.9509 |  | 2001.01.03 | 01:00:00 | / | / | / | /
2001.01.03 | 07:00:00 | 0.951 | 0.951 | 0.9468 | 0.9489 |  | 2001.01.03 | 02:00:00 | / | / | / | /
2001.01.03 | 08:00:00 | 0.949 | 0.9543 | 0.9489 | 0.9539 |  | 2001.01.03 | 03:00:00 | / | / | / | /
2001.01.03 | 09:00:00 | 0.9539 | 0.9549 | 0.9526 | 0.9541 |  | 2001.01.03 | 04:00:00 | / | / | / | /
2001.01.03 | 10:00:00 | 0.9542 | 0.9565 | 0.9534 | 0.9565 |  | 2001.01.03 | 05:00:00 | / | / | / | /
2001.01.03 | 11:00:00 | 0.9564 | 0.9569 | 0.9541 | 0.9547 |  | 2001.01.03 | 06:00:00 | / | / | / | /
2001.01.03 | 12:00:00 | 0.9548 | 0.9549 | 0.9527 | 0.9527 |  | 2001.01.03 | 07:00:00 | / | / | / | /
2001.01.03 | 13:00:00 | 0.9528 | 0.9533 | 0.9503 | 0.9513 |  | 2001.01.03 | 08:00:00 | / | / | / | /
2001.01.03 | 14:00:00 | 0.9513 | 0.952 | 0.9475 | 0.9491 |  | 2001.01.03 | 09:00:00 | / | / | / | /
2001.01.03 | 15:00:00 | 0.9491 | 0.9498 | 0.9444 | 0.9462 |  | 2001.01.03 | 10:00:00 | / | / | / | /
2001.01.03 | 16:00:00 | 0.946 | 0.9477 | 0.945 | 0.9473 |  | 2001.01.03 | 11:00:00 | / | / | / | /
2001.01.03 | 17:00:00 | 0.9474 | 0.9477 | 0.9446 | 0.9449 |  | 2001.01.03 | 12:00:00 | / | / | / | /
2001.01.03 | 18:00:00 | 0.9451 | 0.9463 | 0.9337 | 0.934 |  | 2001.01.03 | 13:00:00 | / | / | / | /
2001.01.03 | 19:00:00 | 0.9341 | 0.9355 | 0.9273 | 0.9288 |  | 2001.01.03 | 14:00:00 | / | / | / | /
2001.01.03 | 20:00:00 | 0.929 | 0.9297 | 0.9275 | 0.9283 |  | 2001.01.03 | 15:00:00 | / | / | / | /
2001.01.03 | 21:00:00 | 0.9284 | 0.9292 | 0.927 | 0.9272 |  | 2001.01.03 | 16:00:00 | / | / | / | /
2001.01.03 | 22:00:00 | 0.9273 | 0.9278 | 0.9262 | 0.9271 |  | 2001.01.03 | 17:00:00 | / | / | / | /
2001.01.03 | 23:00:00 | 0.9271 | 0.9285 | 0.9269 | 0.9283 |  | 2001.01.03 | 18:00:00 | / | / | / | /
2001.01.04 | 1900-01-01 00:00:00 | 0.9283 | 0.9308 | 0.9283 | 0.9301 |  | 2001.01.04 | 19:00:00 | / | / | / | /
2001.01.04 | 01:00:00 | 0.9301 | 0.9306 | 0.929 | 0.9294 |  | 2001.01.04 | 20:00:00 | / | / | / | /
2001.01.04 | 02:00:00 | 0.9294 | 0.9298 | 0.929 | 0.9297 |  | 2001.01.04 | 21:00:00 | / | Find the MAX to previous 5:00 | Find the MIN to previous 5:00 | Match Same Row 7 cells back.
2001.01.04 | 03:00:00 | 0.9297 | 0.9302 | 0.9297 | 0.9301 |  | 2001.01.04 | 22:00:00 | /
2001.01.04 | 04:00:00 | 0.93 | 0.9304 | 0.9299 | 0.9303 |  | 2001.01.04 | 23:00:00 | 0.9506 | 0.9569 | 0.9262 | 0.9303
2001.01.04 | 05:00:00 | 0.9303 | 0.9304 | 0.929 | 0.9291 |  | 2001.01.04 | 1900-01-01 00:00:00 | / | / | / | /
2001.01.04 | 06:00:00 | 0.9291 | 0.9324 | 0.929 | 0.932 |  | 2001.01.04 | 01:00:00 | / | / | / | /
2001.01.04 | 07:00:00 | 0.932 | 0.9416 | 0.9318 | 0.9416 |  | 2001.01.04 | 02:00:00 | / | / | / | /
2001.01.04 | 08:00:00 | 0.9414 | 0.9488 | 0.9414 | 0.9458 |  | 2001.01.04 | 03:00:00 | / | / | / | /
2001.01.04 | 09:00:00 | 0.9459 | 0.9474 | 0.9444 | 0.9472 |  | 2001.01.04 | 04:00:00 | / | / | / | /
2001.01.04 | 10:00:00 | 0.9471 | 0.9515 | 0.9462 | 0.9504 |  | 2001.01.04 | 05:00:00 | / | / | / | /
2001.01.04 | 11:00:00 | 0.9503 | 0.9504 | 0.9457 | 0.9465 |  | 2001.01.04 | 06:00:00 | / | / | / | /
2001.01.04 | 12:00:00 | 0.9464 | 0.9472 | 0.9421 | 0.9469 |  | 2001.01.04 | 07:00:00 | / | / | / | /
2001.01.04 | 13:00:00 | 0.9469 | 0.947 | 0.944 | 0.9466 |  | 2001.01.04 | 08:00:00 | / | / | / | /
2001.01.04 | 14:00:00 | 0.9465 | 0.9474 | 0.9446 | 0.9473 |  | 2001.01.04 | 09:00:00 | / | / | / | /
2001.01.04 | 15:00:00 | 0.9474 | 0.9477 | 0.9436 | 0.9442 |  | 2001.01.04 | 10:00:00 | / | / | / | /
2001.01.04 | 16:00:00 | 0.9443 | 0.9449 | 0.9432 | 0.9444 |  | 2001.01.04 | 11:00:00 | / | / | / | /
2001.01.04 | 17:00:00 | 0.9444 | 0.9489 | 0.9441 | 0.9465 |  | 2001.01.04 | 12:00:00 | / | / | / | /
2001.01.04 | 18:00:00 | 0.9466 | 0.9491 | 0.9466 | 0.9491 |  | 2001.01.04 | 13:00:00 | / | / | / | /
2001.01.04 | 19:00:00 | 0.9491 | 0.9512 | 0.9486 | 0.9496 |  | 2001.01.04 | 14:00:00 | / | / | / | /
2001.01.04 | 20:00:00 | 0.9497 | 0.9502 | 0.9482 | 0.9489 |  | 2001.01.04 | 15:00:00 | / | / | / | /
2001.01.04 | 21:00:00 | 0.9488 | 0.9498 | 0.9487 | 0.9497 |  | 2001.01.04 | 16:00:00 | / | / | / | /
2001.01.04 | 22:00:00 | 0.9497 | 0.951 | 0.9486 | 0.9507 |  | 2001.01.04 | 17:00:00 | / | / | / | /
2001.01.04 | 23:00:00 | 0.9507 | 0.9536 | 0.9506 | 0.9532 |  | 2001.01.04 | 18:00:00 | / | / | / | /
2001.01.05 | 1900-01-01 00:00:00 | 0.9532 | 0.9539 | 0.9523 | 0.9525 |  | 2001.01.05 | 19:00:00 | / | / | / | /
2001.01.05 | 01:00:00 | 0.9525 | 0.9536 | 0.9524 | 0.9534 |  | 2001.01.05 | 20:00:00 | / | / | / | /
2001.01.05 | 02:00:00 | 0.9534 | 0.9548 | 0.9534 | 0.9534 |  | 2001.01.05 | 21:00:00 | / | Match the MAX to previous 5:00 | Match the MIN to previous 5:00 | Match Same Row 7 cells back.
2001.01.05 | 03:00:00 | 0.9534 | 0.9549 | 0.953 | 0.9541 |  | 2001.01.05 | 22:00:00 | /
2001.01.05 | 04:00:00 | 0.9541 | 0.9574 | 0.9541 | 0.9574 |  | 2001.01.05 | 23:00:00 | 0.9303 | 0.9574 | 0.929 | 0.9574
2001.01.06 | 05:00:00