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):
[TABLE="width: 500"]
<tbody>[TR]
[TD]Account Number[/TD]
[TD]Effective Date[/TD]
[TD]System[/TD]
[TD]Next Pmt Date[/TD]
[TD]Payment Amt[/TD]
[/TR]
[TR]
[TD]123456[/TD]
[TD]2/17/2017[/TD]
[TD]IVR[/TD]
[TD]3/13/2017[/TD]
[TD]$200.43[/TD]
[/TR]
[TR]
[TD]254684[/TD]
[TD]2/17/2017[/TD]
[TD]WEB[/TD]
[TD]3/18/2017[/TD]
[TD]$502.47[/TD]
[/TR]
[TR]
[TD]521487[/TD]
[TD]2/17/2017[/TD]
[TD]ACH[/TD]
[TD]3/15/2017[/TD]
[TD]$320.02[/TD]
[/TR]
</tbody>[/TABLE]
I am using an ODBC connection for this one

On a separate tab I have pasted in data:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Account Number[/TD]
[TD]Ref Number[/TD]
[/TR]
[TR]
[TD]254684[/TD]
[TD]123456[/TD]
[/TR]
[TR]
[TD]521487[/TD]
[TD]456789[/TD]
[/TR]
</tbody>[/TABLE]

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...