Spreadsheet: 707319d1607178534-need-value-of-a-lookup-item-number-of-times-in-rows-based-on-its-value-in-other-cell-excel-forum-file
Sheet: example

 | ASIN | External ID | Quantity Requested | Accepted Quantity |  | ASIN | External ID | Quantity Requested | Accepted Quantity
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQLVWT6 | Falkendesign-Acrylic-CL-1/8-2460 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 | Total |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1
 |  |  |  |  |  | B07NQKN5VK | Falkendesign-Acrylic-CL-1/4-3036 | 1 | 1