Parameters from a column for Excel query

[hlhelterbrand]

I am trying to run a query in excel where I can use a column from a different sheet to pull the data I need.

In excel I run a query and pull the follow fields (plus some):

Account Number	Effective Date	System	Next Pmt Date	Payment Amt
123456	2/17/2017	IVR	3/13/2017	$200.43
254684	2/17/2017	WEB	3/18/2017	$502.47
521487	2/17/2017	ACH	3/15/2017	$320.02

<tbody>
</tbody>

I am using an ODBC connection for this one

On a separate tab I have pasted in data:

Account Number	Ref Number
254684	123456
521487	456789

<tbody>
</tbody>

When I put in a parameter into the query:

Value: [parameter]

It only gives me the option to input data from one cell. I have tried with multiple parameters:

Value: [parameter1],[parameter2]

but this would mean I would have to select all of the cells (which can be up to 100.

Is there any way to set up the parameter to select any account number from column A on a separate tab?

 

[hlhelterbrand]

Not sure what I am saying is very clear. Here is some more information

So far my SQL looks like this: (the underlined part is what I am trying to fix)

SELECT DISTINCT ACHFILE.NOACCTNO, ACHFILE.NOEFTDT, ACHFILE.NOUSER, LNMAST.NPDT, ACHFILE.NOPMTAMT, ACHFILE.NOABA#, ACHFILE.NOBANK#, ACHFILE.NOBR#, ACHFILE.NODATE, ACHFILE.NOPMID, CIFFILE_T.CFNA1, CIFFILE_T.CFNA2, CIFFILE_T.CFNA3, CIFFILE_T.CFNA4, MASTER.LPDT, MASTER.NSPDT6, MASTER.ENWRDT, MASTER.FREQ, MASTER.FRCODE, MASTER.PMTCOD, MASTER.ORGAMT, MASTER.CBAL, MASTER.ACCINT, MASTER.ASSLC, MASTER.PAIDLC, MASTER.INTLTD, MASTER.MATDT6, MASTER.TERM, MASTER.PMTAMT, MASTER.FPDT, MASTER.EXTLTD, MASTER.PRTPMT
FROM KUB500A.DATPRD.CIFFILE_T CIFFILE_T, KUB500A.KCCDTAPRD.KACHNOUT KACHNOUT, KUB500A.DATPRD.LNMAST LNMAST
WHERE MASTER.ACCTNO = ACHFILE.NOACCTNO AND CIFFILE_T.CFCIF# = MASTER.CIFNO AND ((ACHFILE.NOACCTNO In (?,?)))
ORDER BY MASTER.FPDT DESC

The column of data that I want to be the criteria is on another tab...