Spreadsheet: 274722d1383206381-how-to-apply-the-function-for-match-and-index-lookup
Sheet: Lookup

 | Invoice Number:
 | 500
 | Amount: | Date:
 | Invoice Number | Amount Due | Date Due
 | 500 | 450 | 2010-08-24 00:00:00
 | 501 | 2745 | 2010-06-05 00:00:00
 | 502 | 980.5 | 2010-08-11 00:00:00
 | 503 | 55.25 | 2010-08-03 00:00:00
 | 504 | 450 | 2010-09-13 00:00:00
 | 505 | 78.95 | 2010-07-03 00:00:00
 | 506 | 125 | 2010-09-02 00:00:00
 | 507 | 980 | 2010-09-01 00:00:00
 | 508 | 127.35 | 2010-08-26 00:00:00
 | 509 | 450 | 2010-02-11 00:00:00
 | 510 | 2745 | 2010-06-02 00:00:00
 | 511 | 980.5 | 2010-08-24 00:00:00
 | 512 | 55.25 | 2010-06-05 00:00:00
 | 513 | 450 | 2010-08-11 00:00:00
 | 514 | 78.95 | 2010-08-03 00:00:00
 | 515 | 125 | 2010-09-13 00:00:00
 | 516 | 980 | 2010-07-03 00:00:00
 | 517 | 127.35 | 2010-09-02 00:00:00
 | 518 | 450 | 2010-09-01 00:00:00
 | 519 | 2745 | 2010-08-26 00:00:00
 | 520 | 980.5 | 2010-02-11 00:00:00
 | 521 | 55.25 | 2010-06-02 00:00:00
 | 522 | 450 | 2010-08-24 00:00:00
 | 523 | 78.95 | 2010-06-05 00:00:00
 | 524 | 125 | 2010-08-11 00:00:00
 | 525 | 980 | 2010-08-03 00:00:00
 | 526 | 127.35 | 2010-09-13 00:00:00
 | 527 | 450 | 2010-07-03 00:00:00
 | 528 | 2745 | 2010-09-02 00:00:00
 | 529 | 980.5 | 2010-09-01 00:00:00
 | 530 | 55.25 | 2010-08-26 00:00:00
 | 531 | 450 | 2010-02-11 00:00:00
 | 532 | 78.95 | 2010-06-02 00:00:00
 | 533 | 125 | 2010-08-24 00:00:00
 | 534 | 980 | 2010-06-05 00:00:00
 | 535 | 127.35 | 2010-08-11 00:00:00
 | 536 | 450 | 2010-08-03 00:00:00
 | 537 | 2745 | 2010-09-13 00:00:00
 | 538 | 980.5 | 2010-07-03 00:00:00
 | 539 | 55.25 | 2010-09-02 00:00:00
 | 540 | 450 | 2010-09-01 00:00:00
 | 541 | 78.95 | 2010-08-26 00:00:00
 | 542 | 125 | 2010-02-11 00:00:00
 | 543 | 980 | 2010-06-02 00:00:00
 | 544 | 127.35 | 2010-08-24 00:00:00
 | 545 | 450 | 2010-06-05 00:00:00
 | 546 | 2745 | 2010-08-11 00:00:00
 | 547 | 980.5 | 2010-08-03 00:00:00
 | 548 | 55.25 | 2010-09-13 00:00:00
 | 549 | 450 | 2010-07-03 00:00:00
 | 550 | 78.95 | 2010-09-02 00:00:00
 | 551 | 125 | 2010-09-01 00:00:00
 | 552 | 980 | 2010-08-26 00:00:00
 | 553 | 127.35 | 2010-02-11 00:00:00
 | 554 | 125 | 2010-06-02 00:00:00
 | 555 | 980 | 2010-08-24 00:00:00
 | 556 | 127.35 | 2010-06-05 00:00:00
 | 557 | 450 | 2010-08-11 00:00:00
 | 558 | 2745 | 2010-08-03 00:00:00
 | 559 | 980.5 | 2010-09-13 00:00:00
 | 560 | 55.25 | 2010-07-03 00:00:00
 | 561 | 450 | 2010-09-02 00:00:00
 | 562 | 78.95 | 2010-09-01 00:00:00
 | 563 | 125 | 2010-08-26 00:00:00
 | 564 | 980 | 2010-02-11 00:00:00
 | 565 | 127.35 | 2010-06-02 00:00:00
 | 566 | 450 | 2010-08-24 00:00:00
 | 567 | 2745 | 2010-06-05 00:00:00
 | 568 | 980.5 | 2010-08-11 00:00:00
 | 569 | 55.25 | 2010-08-03 00:00:00
 | 570 | 450 | 2010-09-13 00:00:00
 | 571 | 78.95 | 2010-07-03 00:00:00
 | 572 | 125 | 2010-09-02 00:00:00
 | 573 | 980 | 2010-09-01 00:00:00
 | 574 | 127.35 | 2010-08-26 00:00:00
 | 575 | 125 | 2010-02-11 00:00:00
 | 576 | 980 | 2010-06-02 00:00:00
 | 577 | 127.35 | 2010-08-24 00:00:00
 | 578 | 450 | 2010-06-05 00:00:00
 | 579 | 2745 | 2010-08-11 00:00:00
 | 580 | 980.5 | 2010-08-03 00:00:00
 | 581 | 55.25 | 2010-09-13 00:00:00
 | 582 | 450 | 2010-07-03 00:00:00
 | 583 | 78.95 | 2010-09-02 00:00:00
 | 584 | 125 | 2010-09-01 00:00:00
 | 585 | 980 | 2010-08-26 00:00:00
 | 586 | 127.35 | 2010-02-11 00:00:00
 | 587 | 450 | 2010-06-02 00:00:00
 | 588 | 2745 | 2010-08-24 00:00:00
 | 589 | 980.5 | 2010-06-05 00:00:00
 | 590 | 55.25 | 2010-08-11 00:00:00
 | 591 | 450 | 2010-08-03 00:00:00
 | 592 | 78.95 | 2010-09-13 00:00:00
 | 593 | 125 | 2010-07-03 00:00:00
 | 594 | 980 | 2010-09-02 00:00:00
 | 595 | 127.35 | 2010-09-01 00:00:00
 | 596 | 125 | 2010-08-26 00:00:00
 | 597 | 980 | 2010-02-11 00:00:00
 | 598 | 127.35 | 2010-06-02 00:00:00
 | 599 | 450 | 2010-08-24 00:00:00
 | 600 | 2745 | 2010-06-05 00:00:00