I am running into a weird DGET error in Google Sheets.
in one table, I have the following entries:
Column A Column B
Horse Wins
Daedalus I 15
Daedalus II 12
Panacea I 10
Panacea II 9
when I use
=dget(A1:B5,"Wins",{"Horse";"Daedalus I"})
I get a #NUM!
error. However, if I change the table from "Daedalus II" to "Daedalus 2", the error is gone.
-
Is this the expected behavior or a bug in Google Sheets?
-
Any way to circumvent this without changing the table?
Best Answer
@James/mreighties posted an answer on Google, that I am copying here for future reference:
Hello,
I may have found the answer at this site...
https://infoinspired.com/google-docs/spreadsheet/exact-match-in-database-functions-in-google-sheets/
...and changed your formula to this...
...and it works for me. Take a look at my testing sheet...
https://docs.google.com/spreadsheets/d/1EoTytnKAIrrRmRwPX9k2xdEKeJMk4i5O3BtIXjaVSc4/edit?usp=sharing
...where in
F2
is this formula......which hardcodes the criteria in the formula.
And in
H2
is this formula......which looks at the choice made from the drop-down in
D2
to use as the criteria in the formula.James :)