I want to do a dget function but the information needed in rows rather than a
column.

Is there a way to convert within the formula for dget this row-wise criteria
data. It is a large table and would not be able to create the criteria on
the side and manage the formula
dget(dbname,dbcolnm,d1:d2) table is 700 plus rows and I do not want to
create 700 critera cells ..... would like to generate array using the values
of the cells resulting in d1,d2 then in the next row d1,d3, then in the next
row d1,d4