Sorry for a beginner question, but I’ve tried everything I can think of already. I’m doing a large database of over 900 entries/rows, and a list which puts them in numeric order from smallest to biggest, and thus I use function as a parameter. I checked your example and advices from help pages regarding DGET(Database; DatabaseField; SearchCriteria) and tried several approaches. Maybe it was a ghost bug because I had done already worked the table, but it should had gone away if that was the case because I tried all the approaches. Tried putting everything on the same line, tried using both functions and numeric values as search criterias, tried using both brackets ‘’ and “”"" for the column tag, put the database and searchcriteria on different and same columns. Changing brackets gave me #VALUE! error instead of 504.
Do only numeric values work in DGET(Database; DatabaseField; SearchCriteria) , or can I use functions as SearchCriteria?
Also, if I understood right, DatabaseField is the syntax which determines the kind of result (column) shown in the cell.
Also, should Database always be positioned above SearchCriteria in the table?
I think you should put that to your help page with highlighted font if it accepts certain functions with only very restricted formalities, because knowing that would save a lot of time and experimenting from users like myself who are not familiar with programming and why programs are built the way they are.