Using DGET to extract multiple records
Bob wrote...
Yes, but I'm looking for an automatic way (i.e., using a built-in
function or UDF).
....
Something like the following to get the _i_th row mathcing your
criteria and the _j_th column in that row.
=INDEX(Table,SMALL(IF(Criteria,ROW(Table)-MIN(ROW(Table))+1),i),j)
Table is a token reference to the table of data you're trying to
filter. Criteria is a placeholder for the criteria expression you want
to use.
|