databaseexcelrowcriteria
How to query two consecutive "criteria rows" with DGET in Excel?
where DB.VALORI function is DGET in english.
For the queries, the rule is that the criteria row must be under the label row. The query 1 is ok, is there a way to add query 2?
Solution
I personally don't use this DGET function but someone can probably help you here. This is another way you can try with an array formula (click Ctrl + Shift + Enter together):
=INDEX($D$2:$D$5,MATCH(G2&H2&I2,$A$2:$A$5&$B$2:$B$5&$C$2:$C$5,0))
This can do multiple matches and find the result you want. Give it a shot and let me know if you have any question.
P.S. You will need to translate the formula function to your language and doesn't forget to change , to ; in the formula.
- How to list all the removable devices with DBus and UDisks2?
- gobject/gnome/glib bindings for D using GIR?
- How do nested functions get compiled?
- The "this" pointer and message receiving in D
- 64-bit executables with DMD
- GtkD with D lang on Fedora
- Why Android used Java concept instead of D language or C or C++? But Chromium web browser is in C++, its very complicated match
- How to use MongoItemWriter to write a List<T>
- Why a function with protected modifier can be overridden and accessible every where?
- Convert Unicode const(uint)* to a dlang character type
- Compiling D with Code::Blocks
- DMD vs. GDC vs. LDC
- Rendering a font in raylib using freetype
- Digital Mars D compiler; acquiring ASM output
- D Programming: openssl rsa forward reference compiler error
- D compiler DMD doesn't link object files
- OPTLINK: Warning 23: No Stack
- Is there a limit in the amount of temporary generated symbols during a project build using dmd 2.063?
- Is this the right way to combine Garbage collected with none Garbage collected code in D
- D compiler (Digital Mars D Compiler) throwing error
- Which D Compiler to Use?
- Splitting a string treating multiple whitespace as one separator
- Proper way of passing array parameters to D functions
- Detailed Valgrind internals documentation
- Is it possible, in D, to tell the garbage collector to not scan a particular pointer (or anything below it)?
- Iterate over key/value pairs in associative array in D.
- Dlang associative array of an array of strings keyed by a string has unexpected behavior
- How to repeat a statement N times (simple loop)
- Is worth the effort to learn D?
- ld: undefined reference to object I can see in objdump