Spreadsheet: 841700d1693879327-looking-for-lookup-function-that-return-the-last-matching-value-lastmatchingvalue
Sheet: Sheet1

P/N | [NAME] | Last buy QTY |  |  |  |  | partno | podate | descript | manufacter | [NAME] | onorder
A002 | RES SMD 0805 560R 1% NB | 10000 |  |  |  |  | A001 | 06/10/2015 | RES SMD 0805 270R 1% NB | SAMSUNG | RC2012F271CS | 10000
A006 | RES SMD 0805 2K2 1% NB | 10000 |  |  |  |  | A001 | 29/03/2016 | RES SMD 0805 270R 1% NB | SAMSUNG | RC2012F271CS | 5000
A008 | RES SMD 0805 100K 1% NB | 15000 |  |  |  |  | A001 | 29/03/2016 | RES SMD 0805 270R 1% NB | SAMSUNG | RC2012F271CS | 5000
A009 | RES SMD 0805 1K 1% NB | 10000 |  |  |  |  | A001 | 16/01/2017 | RES SMD 0805 270R 1% NB | SAMSUNG | RC2012F271CS | 15000
A011 | RES SMD 0805 68K 1% NB | 5000 |  |  |  |  | A001 | 25/02/2021 | RES SMD 0805 270R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 270R | 10000
 |  |  |  |  |  |  | A002 | 19/08/2011 | RES SMD 0805 560R 1% NB | PHYCOMP | 2322 734 65601 | 20000
 |  |  |  |  |  |  | A002 | 29/05/2012 | RES SMD 0805 560R 1% NB | PHYCOMP | 2322 734 65601 | 10000
 |  |  |  |  |  |  | A002 | 25/07/2013 | RES SMD 0805 560R 1% NB | PHYCOMP | 2322 734 65601 | 20000
 |  |  |  |  |  |  | A002 | 12/03/2015 | RES SMD 0805 560R 1% NB | SAMSUNG | RC2012F561CS | 10000
 |  |  |  |  |  |  | A002 | 15/01/2016 | RES SMD 0805 560R 1% NB | YAGEO/PHYCOMP | RC0805FR-07560RL | 15000
 |  |  |  |  |  |  | A002 | 16/01/2017 | RES SMD 0805 560R 1% NB | YAGEO/PHYCOMP | RC0805FR-07560RL | 15000
 |  |  |  |  |  |  | A002 | 19/09/2019 | RES SMD 0805 560R 1% NB | YAGEO/PHYCOMP | RC0805FR-07560RL | 10000
 |  |  |  |  |  |  | A002 | 20/09/2021 | RES SMD 0805 560R 1% NB | YAGEO/PHYCOMP | RC0805FR-07560RL | 10000
 |  |  |  |  |  |  | A003 | 26/09/2018 | RES SMD 0805 100R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100RL | 5000
 |  |  |  |  |  |  | A003 | 19/09/2019 | RES SMD 0805 100R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100RL | 15000
 |  |  |  |  |  |  | A003 | 29/05/2020 | RES SMD 0805 100R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100RL | 10000
 |  |  |  |  |  |  | A003 | 16/08/2022 | RES SMD 0805 100R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100RL | 10000
 |  |  |  |  |  |  | A004 | 15/01/2019 | RES SMD 0805 10R 1% NB | YAGEO/PHYCOMP | RC0805FR-0710RL | 5000
 |  |  |  |  |  |  | A004 | 19/09/2019 | RES SMD 0805 10R 1% NB | YAGEO/PHYCOMP | RC0805FR-0710RL | 10000
 |  |  |  |  |  |  | A004 | 29/05/2020 | RES SMD 0805 10R 1% NB | SAMSUNG | RC2012F100CS | 10000
 |  |  |  |  |  |  | A004 | 11/04/2023 | RES SMD 0805 10R 1% NB | YAGEO/PHYCOMP | RC0805FR-0710RL | 10000
 |  |  |  |  |  |  | A005 | 14/05/2019 | RES SMD 0805 220R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 220RL | 10000
 |  |  |  |  |  |  | A005 | 04/11/2019 | RES SMD 0805 220R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 220RL | 15000
 |  |  |  |  |  |  | A005 | 29/05/2020 | RES SMD 0805 220R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 220RL | 10000
 |  |  |  |  |  |  | A005 | 16/08/2022 | RES SMD 0805 220R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 220RL | 10000
 |  |  |  |  |  |  | A005 | 08/06/2023 | RES SMD 0805 220R 1% NB | YAGEO/PHYCOMP | RC0805FR-07 220RL | 10000
 |  |  |  |  |  |  | A006 | 02/02/2015 | RES SMD 0805 2K2 1% NB | SAMSUNG | RC2012F222CS | 10000
 |  |  |  |  |  |  | A006 | 06/10/2015 | RES SMD 0805 2K2 1% NB | SAMSUNG | RC2012F222CS | 10000
 |  |  |  |  |  |  | A006 | 29/03/2016 | RES SMD 0805 2K2 1% NB | YAGEO/PHYCOMP | RC0805FR-07 2K2L | 10000
 |  |  |  |  |  |  | A006 | 16/01/2017 | RES SMD 0805 2K2 1% NB | SAMSUNG | RC2012F222CS | 10000
 |  |  |  |  |  |  | A006 | 26/03/2019 | RES SMD 0805 2K2 1% NB | YAGEO/PHYCOMP | RC0805FR-07 2K2L | 5000
 |  |  |  |  |  |  | A006 | 04/11/2019 | RES SMD 0805 2K2 1% NB | YAGEO/PHYCOMP | RC0805FR-07 2K2L | 5000
 |  |  |  |  |  |  | A006 | 22/12/2020 | RES SMD 0805 2K2 1% NB | YAGEO/PHYCOMP | RC0805FR-07 2K2L | 10000
 |  |  |  |  |  |  | A007 | 06/12/2005 | RES SMD 0805 68R 1% NB | PHYCOMP | 2322-734-66809 | 5000
 |  |  |  |  |  |  | A007 | 13/06/2007 | RES SMD 0805 68R 1% NB | PHYCOMP | 2322-734-66809 | 10000
 |  |  |  |  |  |  | A007 | 11/07/2019 | RES SMD 0805 68R 1% NB | SAMSUNG | RC2012F680CS | 10000
 |  |  |  |  |  |  | A008 | 29/03/2016 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 35000
 |  |  |  |  |  |  | A008 | 16/01/2017 | RES SMD 0805 100K 1% NB | SAMSUNG | RC2012F104CS | 50000
 |  |  |  |  |  |  | A008 | 26/09/2018 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 15000
 |  |  |  |  |  |  | A008 | 19/09/2019 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 25000
 |  |  |  |  |  |  | A008 | 29/05/2020 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 15000
 |  |  |  |  |  |  | A008 | 22/04/2022 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 15000
 |  |  |  |  |  |  | A008 | 11/04/2023 | RES SMD 0805 100K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 100KL | 15000
 |  |  |  |  |  |  | A009 | 14/09/2017 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 20000
 |  |  |  |  |  |  | A009 | 14/09/2017 | RES SMD 0805 1K 1% NB | SAMSUNG | RC2012F102CS | 5000
 |  |  |  |  |  |  | A009 | 26/09/2018 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 20000
 |  |  |  |  |  |  | A009 | 14/05/2019 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 20000
 |  |  |  |  |  |  | A009 | 19/09/2019 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 25000
 |  |  |  |  |  |  | A009 | 29/05/2020 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 35000
 |  |  |  |  |  |  | A009 | 25/02/2021 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 20000
 |  |  |  |  |  |  | A009 | 16/08/2022 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 10000
 |  |  |  |  |  |  | A009 | 13/10/2022 | RES SMD 0805 1K 1% NB | YAGEO/PHYCOMP | [NAME] | 10000
 |  |  |  |  |  |  | A010 | 20/02/2013 | RES SMD 0805 47K 1% NB | YEAGEO | RC0805FR-07 47K | 10000
 |  |  |  |  |  |  | A010 | [NAME] | RES SMD 0805 47K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 47KL | 10000
 |  |  |  |  |  |  | A010 | 15/01/2016 | RES SMD 0805 47K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 47KL | 15000
 |  |  |  |  |  |  | A010 | 16/01/2017 | RES SMD 0805 47K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 47KL | 10000
 |  |  |  |  |  |  | A010 | 04/11/2019 | RES SMD 0805 47K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 47KL | 5000
 |  |  |  |  |  |  | A010 | 20/04/2021 | RES SMD 0805 47K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 47KL | 5000
 |  |  |  |  |  |  | A011 | 04/02/2014 | RES SMD 0805 68K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 68KL | 10000
 |  |  |  |  |  |  | A011 | 02/02/2015 | RES SMD 0805 68K 1% NB | SAMSUNG | RC2012F683CS | 10000
 |  |  |  |  |  |  | A011 | 29/03/2016 | RES SMD 0805 68K 1% NB | SAMSUNG | RC2012F683CS | 10000
 |  |  |  |  |  |  | A011 | 26/09/2018 | RES SMD 0805 68K 1% NB | YAGEO/PHYCOMP | RC0805FR-07 68KL | 5000
 |  |  |  |  |  |  | A011 | 11/07/2019 | RES SMD 0805 68K 1% NB | SAMSUNG | RC2012F683CS | 5000