Certain Spread functions (VT, VINFO, DDVT, MVSTAT ) allow you to specify the variable via an SQL Where Clause instead of a VarNum or reference to a cell with a VarNum.
The WHERE Clause must be a valid SQL and refer to the VARDESC/LOCATION tables.
Referring to a Cell value in the Where clause. Use the syntax CELL(A1) to use the value of a cell in the query. NOTE: Cell references are NOT updated when the cell is moved, columns/rows inserted, etc. The "?" can be used in place of the Column or row specification to indicate the current row/col. Example, CELL(B?) refers to column B and the current row the formula is in.
VT("LOCATION.PWSID='CELL(B2)' and NAME LIKE '%Total Coliform PA'",1) - NOTE: CELL(B2) will return the value in the cell from B2, NM0680123 in this case.
SQL Statement would become:
FROM VARDESC LEFT OUTER JOIN LOCATION ON VARDESC.LOCID=LOCATION.LOCID
WHERE LOCATION.PWSID='NM0680123' AND NAME LIKE '%Total Coliform PA'
ORDER BY VARNUM
VINFO("VARDESC.LOCID=CELL(B?) AND NAME LIKE '%pH'","DECPLACES") - If Formula is in E6, would find the LOCID in cell B6.
MVSTAT("AVG",1,"R","LOCATION.LVL1_ID =10 AND NAME LIKE '%Free Chlorine'")