I want to use the DGET function to populate a results table in an excel spreadsheet. Two of the "criteria" I'm using for the DGET function will be stored in the first row and first column of the output table. Unfortunately, it looks like DGET requires a contiguous array to be used as the "criteria" input. I have tried using an array constant (i.e. a hardcoded array using curly braces {}), but am getting errors. There seem to be two separate problems occurring:
1. The DGET function returns an error when I try to use an array constant
2. I don't think array constants can contain cell references; they literally have to be constants.
Any input will be greatly appreciated. I've attached a spreadsheet showing an example of the problem.
Thanks!
Bookmarks