I am trying to do a Google Sheet Lookup Spreadsheet Rows, from a Xero Trigger. The Xero value is the Item Code of the item(s) sold, and usually there’s more than one at once.

How do I lookup multiple values at once so that I can adjust each product inventory quantity?