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
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?