Dependant Dropdown

I am trying to scan in orders from a set of data called, client_inventory. I am scanning in the orders using a separate spreadsheet.

I am trying to create a slice that I can use in the Valid IF statement so it will eliminate the items already scanned.

Is there a way to create a SELECT statement that can look if the value exists in another table?

Hello @Dan_Oliphant , yes, you can use list expressions for that purpose:

2 Likes