How do I search multiple item codes in a cell reference?

[jnilsson2810]

Goal: Search a dynamic list of items to plug into a sales order query from a cell reference.

I know how to reference a cell reference for only one item that can change in a cell reference, but I now need to know how to reference a cell or cells that have multiple items and filter to just those items in a sales order query in Microsoft Query.

Here is the syntax for just one item cell reference:

SO_SALESORDERDETAIL.ITEMCODE=?

The question mark means that it is an input from what I know.

I can reference one item, but not multiple.

I just need to know the right code how to search multiple items from a spreadsheet.

Any direction and feedback is much appreciated. Thanks!

 

[alansidman]

Suggest you post some sample data of before and after. Use XL2BB. Your explanation is not quite clear enough and a visual may help.

 

[jnilsson2810]

PO_PURCHASEORDERDETAIL.ITEMCODE=?

This code is on the Purchase Order side, but it's the same concept for the SO side.

The question mark means that I can use it as a cell reference. I only know how to search one item at a time, but I want to know how to query/filter to a cell reference or a list of items in a column into SQL code so that I can search multiple items based on a cell reference.

I uploaded some images to help show you what I mean by searching one at a time.

 

[jnilsson2810]

I don't know if it's possible, but I'm wondering if I could put a list of items like 344196, 660508, 660509, etc. in one cell in order to search multiple at a time.