Spreadsheet: 716194d1612097138-lookup-partial-data-from-a-cell-and-then-match-contents-of-its-row-to-another-worksheet-book1
Sheet: Sheet5

Sales Invoice | S.NO. | Snum | PO # | Qty | Unit Price | Total | Used | [NAME]
MAGI/20-21/043 | 2006MG02642 | L2021-6 | PUR/2021/003/A | 5 | 1127 | 5635 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-6 | PUR/2021/003/A | 5 | 1127 | 5635 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-6 | PUR/2021/003/A | 5 | 1127 | 5635 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-6 | PUR/2021/003/A | 5 | 1127 | 5635 | 0 | 0850-2645
MAGI/20-21/043 | 2006MG02642 | L2021-7 | PUR/2021/003/A | 5 | 972 | 4860 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-7 | PUR/2021/003/A | 5 | 972 | 4860 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-7 | PUR/2021/003/A | 5 | 972 | 4860 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-7 | PUR/2021/003/A | 5 | 972 | 4860 | 0 | 0850-2645
MAGI/20-21/043 | 2006MG02642 | L2021-8 | PUR/2021/003/A | 10 | 203 | 2030 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-8 | PUR/2021/003/A | 10 | 203 | 2030 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-8 | PUR/2021/003/A | 10 | 203 | 2030 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-8 | PUR/2021/003/A | 10 | 203 | 2030 | 0 | 0850-2645
MAGI/20-21/043 | 2006MG02642 | L2021-9 | PUR/2021/004/A | 2 | 1610 | 3220 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-9 | PUR/2021/004/A | 2 | 1610 | 3220 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-9 | PUR/2021/004/A | 2 | 1610 | 3220 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-9 | PUR/2021/004/A | 2 | 1610 | 3220 | 0 | 0850-2645
MAGI/20-21/043 | 2006MG02642 | L2021-10 | PUR/2021/004/A | 2 | 1575 | 3150 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-10 | PUR/2021/004/A | 2 | 1575 | 3150 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-10 | PUR/2021/004/A | 2 | 1575 | 3150 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-10 | PUR/2021/004/A | 2 | 1575 | 3150 | 0 | 0850-2645
MAGI/20-21/043 | 2006MG02642 | L2021-14 | PUR/2021/005/A | 1 | 9000 | 9000 | 0 | 0850-2642
MAGI/20-21/043 | 2006MG02645 | L2021-14 | PUR/2021/005/A | 1 | 9000 | 9000 | 0 | 0850-2645
MAGI/20-21/044 | 2006MG02642 | L2021-14 | PUR/2021/005/A | 1 | 9000 | 9000 | 0 | 0850-2642
MAGI/20-21/044 | 2006MG02645 | L2021-14 | PUR/2021/005/A | 1 | 9000 | 9000 | 0 | 0850-2645
MAGI/20-21/027 | 2005MG02598 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2598
MAGI/20-21/027 | 2005MG02600 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2600
MAGI/20-21/027 | 2005MG02602 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2602
MAGI/20-21/027 | 2006MG02648 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2648
MAGI/20-21/027 | 2006MG02649 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2649
MAGI/20-21/027 | 2006MG02650 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2650
MAGI/20-21/031 | 2005MG02598 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2598
MAGI/20-21/031 | 2005MG02600 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2600
MAGI/20-21/031 | 2005MG02602 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2602
MAGI/20-21/031 | 2006MG02648 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2648
MAGI/20-21/031 | 2006MG02649 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2649
MAGI/20-21/031 | 2006MG02650 | L2021-26 | PUR/2021/008/A | 10 | 6000 | 60000 | 0 | Stock2650
MAGI/20-21/027 | 2005MG02597 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2597
MAGI/20-21/027 | 2005MG02599 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2599
MAGI/20-21/027 | 2005MG02601 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2601
MAGI/20-21/027 | 2006MG02648 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2648
MAGI/20-21/027 | 2006MG02649 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2649
MAGI/20-21/027 | 2006MG02650 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2650
MAGI/20-21/031 | 2005MG02597 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2597
MAGI/20-21/031 | 2005MG02599 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2599
MAGI/20-21/031 | 2005MG02601 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2601
MAGI/20-21/031 | 2006MG02648 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2648
MAGI/20-21/031 | 2006MG02649 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2649
MAGI/20-21/031 | 2006MG02650 | L2021-32 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2650
MAGI/20-21/027 | 2005MG02598 | L2021-33 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2598
MAGI/20-21/027 | 2005MG02600 | L2021-33 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2600
MAGI/20-21/027 | 2005MG02602 | L2021-33 | PUR/2021/012/A | 10 | 15 | 150 | 0 | Stock2602
MAGI/20-21/018 | 2005MG02626 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2626
MAGI/20-21/018 | 2005MG02627 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2627
MAGI/20-21/018 | 2005MG02628 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2628
MAGI/20-21/018 | 2005MG02629 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2629
MAGI/20-21/018 | 2005MG02630 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2630
MAGI/20-21/018 | 2005MG02631 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2631
MAGI/20-21/018 | 2005MG02632 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2632
MAGI/20-21/018 | 2005MG02633 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2633
MAGI/20-21/039 | 2005MG02626 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2626
MAGI/20-21/039 | 2005MG02627 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2627
MAGI/20-21/039 | 2005MG02628 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2628
MAGI/20-21/039 | 2005MG02629 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2629
MAGI/20-21/039 | 2005MG02630 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2630
MAGI/20-21/039 | 2005MG02631 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2631
MAGI/20-21/039 | 2005MG02632 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2632
MAGI/20-21/039 | 2005MG02633 | L2021-65 | PUR/2021/028/A | 8 | 180 | 1440 | 0 | 0945-2633
MAGI/20-21/039 | 2005MG02634 | L2021-66 | PUR/2021/028/A | 3 | 180 | 540 | 0 | 0945-2634
MAGI/20-21/039 | 2005MG02635 | L2021-66 | PUR/2021/028/A | 3 | 180 | 540 | 0 | 0945-2635
MAGI/20-21/039 | 2005MG02636 | L2021-66 | PUR/2021/028/A | 3 | 180 | 540 | 0 | 0945-2636