Results 1 to 6 of 6

DGET with a hardcoded array for "criteria"

Threaded View

  1. #1
    Registered User
    Join Date
    03-30-2012
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    12

    DGET with a hardcoded array for "criteria"

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1