Spreadsheet: 82531d1282593715-vlookup-with-multiple-row-data-returns-vlookup-multiple-rows2
Sheet: Sheet2

list |  |  |  | helper
EZBAKE ENR BD V4 | TOP | 5 | STL0751 | 1-EZBAKE ENR BD V4
EZBAKE ENR BD V4 | BOT | 5 | [NAME] | 2-EZBAKE ENR BD V4 |  | unique list (extracted using advanced filter on column a unique vales/copy to location)
04-06-0558 | TOP | 4 | STL0763 | 1-04-06-0558 |  | USING TO LOOK UP | 1ST FIND | 2ND FIND | 3RD FIND | 4th FIND | 5th FIND
04-06-0558 | TOP | 5 | STL0764 | 2-04-06-0558 |  | list
04-06-0558 | TOP | 5 | STL0765 | 3-04-06-0558 |  | EZBAKE ENR BD V4 | TOP | BOT
W50M-331 | BOT | 4 | STL0767 | 1-W50M-331 |  | 04-06-0558 | TOP | TOP | TOP
W50M-331 | TOP | 4 | STL0768 | 2-W50M-331 |  | W50M-331 | BOT | TOP
LIG DARWIN APP1R2 | BOTH | 5 | STL0770 | 1-LIG DARWIN APP1R2 |  | LIG DARWIN APP1R2 | BOTH
04-06-0581 | TOP | 5 | STL0771 | 1-04-06-0581 |  | 04-06-0581 | TOP | TOP
04-06-0772 | TOP | 5 | STL0772 | 1-04-06-0772 |  | 04-06-0772 | TOP
04-06-0581 | TOP | 5 | STL0773 | 2-04-06-0581 |  | 04-06-0641 | TOP
04-06-0641 | TOP | 5 | STL0774 | 1-04-06-0641 |  | 262-772010 | BOT | TOP
262-772010 | BOT | 6 | STL0775 | 1-262-772010 |  | 262-772010-1R5 | TOP | BOT
262-772010 | TOP | 6 | STL0776 | 2-262-772010 |  | 262-772020-1R2 | TOP | BOT
262-772010-1R5 | TOP | 5 | STL0782 | 1-262-772010-1R5 |  | 262-772170-1R3 | TOP
262-772010-1R5 | BOT | 5 | STL0783 | 2-262-772010-1R5 |  | PN-1685-R02 | BOTH
262-772020-1R2 | TOP | 5 | STL0784 | 1-262-772020-1R2 |  | PN-1686-R02 | BOTH
262-772020-1R2 | BOT | 5 | STL0785 | 2-262-772020-1R2 |  | EMULSIFIER BDV3 | TOP | BOT
262-772170-1R3 | TOP | 5 | STL0786 | 1-262-772170-1R3 |  | 04-06-0718 | TOP
PN-1685-R02 | BOTH | 4 | [NAME] | 1-PN-1685-R02 |  | 262-772060-1R5 | TOP | BOT
PN-1686-R02 | BOTH | 4 | STL0788 | 1-PN-1686-R02 |  | 04-06-0778 | TOP
EMULSIFIER BDV3 | TOP | 5 | STL0789 | 1-EMULSIFIER BDV3 |  | 35-4800-6109-03 | BOT
EMULSIFIER BDV3 | BOT | 5 | STL0790 | 2-EMULSIFIER BDV3 |  | 04-06-0753 | TOP
04-06-0718 | TOP | 5 | STL0791 | 1-04-06-0718 |  | 04-06-0797 | TOP
262-772060-1R5 | TOP | 5 | STL0792 | 1-262-772060-1R5 |  | 500-1890-02 | TOP
262-772060-1R5 | BOT | 5 | STL0793 | 2-262-772060-1R5 |  | 262-772000-1R7 | BOTH
04-06-0778 | TOP | 5 | STL0794 | 1-04-06-0778 |  | 04-06-0756 | TOP
35-4800-6109-03 | BOT | 6 | STL0795 | 1-35-4800-6109-03 |  | 04-06-0777 | TOP
04-06-0753 | TOP | 5 | STL0796 | 1-04-06-0753 |  | TOL-1313 | TOP
04-06-0797 | TOP | 5 | STL0797 | 1-04-06-0797 |  | 262-772020-1R3 | TOP | BOT
500-1890-02 | TOP | 5 | STL0798 | 1-500-1890-02 |  | 04-06-0788 | TOP
262-772000-1R7 | BOTH | 5 | STL0799 | 1-262-772000-1R7 |  | 500-1892-00RA | TOP
04-06-0756 | TOP | 5 | STL0800 | 1-04-06-0756 |  | 04-06-0791 | TOP
04-06-0777 | TOP | 5 | STL0801 | 1-04-06-0777 |  | 35-4000-6082-02 | BOT
TOL-1313 | TOP | 5 | STL0802 | 1-TOL-1313 |  | 262-772030-1R6 | BOT
262-772020-1R3 | TOP | 5 | STL0803 | 1-262-772020-1R3 |  | HPDC-V2 | TOP O
262-772020-1R3 | BOT | 5 | STL0804 | 2-262-772020-1R3 |  | DLDD-V51 | BOTH
04-06-0788 | TOP | 5 | STL0805 | 1-04-06-0788 |  | 04-06-0768 | TOP
500-1892-00RA | TOP | 5 | STL0806 | 1-500-1892-00RA |  | PCB-CRTGUN-01 | TOP O
04-06-0791 | TOP | 5 | STL0807 | 1-04-06-0791
35-4000-6082-02 | BOT | 6 | [NAME] | 1-35-4000-6082-02
262-772030-1R6 | BOT | 5 | STL0809 | 1-262-772030-1R6
HPDC-V2 | TOP O | 5 | STL0810 | 1-HPDC-V2
DLDD-V51 | BOTH | 5 | STL0811 | 1-DLDD-V51
04-06-0768 | TOP | 5 | STL0812 | 1-04-06-0768
PCB-CRTGUN-01 | TOP O | 5 | STL0813 | 1-PCB-CRTGUN-01