Take only required data from spreadsheet

ginochambers There are a couple of formulas you could try involving the FILTER function, if it's available in your version of Excel. Use either the COUNTIF method or the ISNUMBER/XMATCH method shown below, to filter by a list of SKU values:

=FILTER(table, COUNTIF(sku_list, sku_range))
=FILTER(table, ISNUMBER(XMATCH(sku_range, sku_list)))

Also, if your master table includes multiple product lists by supplier in the same table, include additional criteria to filter by supplier:

=FILTER(table, (supplier_range="Supplier Name")*COUNTIF(sku_list, sku_range))
=FILTER(table, (supplier_range="Supplier Name")*ISNUMBER(XMATCH(sku_range, sku_list)))

For a demonstration of the ISNUMBER/XMATCH method, check out Mike Girvin's Excel FILTER Function to Extract Records Based on Items in a List video on his YouTube channel.