Spreadsheet: 474724d1470867419-returning-greatest-and-lowest-value-involving-index-match-formula-sample
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  | PO# |  |  |  |  |  |  | Amount - Open |  | Close Order
 |  |  |  |  |  |  |  |  |  | 379604 |  |  |  |  |  |  | 8050 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 402702 |  |  |  |  |  |  | 11618 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 431837 |  |  |  |  |  |  | 6569.81 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 432641 |  |  |  |  |  |  | 14737.57 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 442478 |  |  |  |  |  |  | 16578.34 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 450898 |  |  |  |  |  |  | 46628.31 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 454313 |  |  |  |  |  |  | 6517 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 457904 |  |  |  |  |  |  | 8115.65 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 464303 |  |  |  |  |  |  | 39500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 478940 |  |  |  |  |  |  | 6900 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 480807 |  |  |  |  |  |  | 110555.31 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 489783 |  |  |  |  |  |  | 30500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 495236 |  |  |  |  |  |  | 6933 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 504986 |  |  |  |  |  |  | 20192.62 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 513863 |  |  |  |  |  |  | 6800 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 516626 |  |  |  |  |  |  | 13915 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 525699 |  |  |  |  |  |  | 88423 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 531937 |  |  |  |  |  |  | 24501 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 535580 |  |  |  |  |  |  | 5202 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 543732 |  |  |  |  |  |  | 32339 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 543938 |  |  |  |  |  |  | 256491 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 544751 |  |  |  |  |  |  | 60135 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 547357 |  |  |  |  |  |  | 355518 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 547358 |  |  |  |  |  |  | 205105 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548427 |  |  |  |  |  |  | 63015 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548757 |  |  |  |  |  |  | 274500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 548759 |  |  |  |  |  |  | 62750 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551352 |  |  |  |  |  |  | 26013 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551361 |  |  |  |  |  |  | 10850 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551375 |  |  |  |  |  |  | 13634 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 551391 |  |  |  |  |  |  | 56371 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 553199 |  |  |  |  |  |  | 209181 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 554419 |  |  |  |  |  |  | 18250 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558132 |  |  |  |  |  |  | 43014 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558135 |  |  |  |  |  |  | 46588 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558235 |  |  |  |  |  |  | 27200 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 558918 |  |  |  |  |  |  | 82500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 559663 |  |  |  |  |  |  | 25472 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 563964 |  |  |  |  |  |  | 7963 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 563969 |  |  |  |  |  |  | 47950 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 564051 |  |  |  |  |  |  | 16014.5 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 564907 |  |  |  |  |  |  | 39500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 564970 |  |  |  |  |  |  | 18325 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565335 |  |  |  |  |  |  | 24850 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565339 |  |  |  |  |  |  | 85500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 565344 |  |  |  |  |  |  | 12701 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 566013 |  |  |  |  |  |  | 47044 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 568609 |  |  |  |  |  |  | 41577 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 568847 |  |  |  |  |  |  | 13800 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 570081 |  |  |  |  |  |  | 39500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 575450 |  |  |  |  |  |  | 20482 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576076 |  |  |  |  |  |  | 5000 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576124 |  |  |  |  |  |  | 12500 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576125 |  |  |  |  |  |  | 98600 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576149 |  |  |  |  |  |  | 8140 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576454 |  |  |  |  |  |  | 10327 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576595 |  |  |  |  |  |  | 7600 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576735 |  |  |  |  |  |  | 27223 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 576741 |  |  |  |  |  |  | 5855 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 577803 |  |  |  |  |  |  | 8750 |  | Accrue
 |  |  |  |  |  |  |  |  |  | 580325 |  |  |  |  |  |  | 206636 |  | Accrue