Database function criteria

M

Maistrye

Hi,

Essentially, I would like to be able to specify the criteria inside the
formulae DGET, DSUM, etc. as opposed to referencing cells elsewhere in
the spreadsheet. I'll give a bit of an example (and yes, I know for
this example there are other convenient ways to do it, that's not the
point):

Limitations:
- No VBA (can't be guaranteed others will turn on macros)

Database: Let it be called "db" for reference below.
Key Value
A 5
B 6
C 7

List:
Key OtherInfo Value
A Something [Formula]
A Whatever [Formula]
B YetMore [Formula]

Where the [Formula] is = DGET(db, "Value", [Criteria])
Where the [Criteria] is generated based on the key value in the current
row. ie. for the first row in the List, it would be Key = A, and so
on.

So, is there any way to assemble the criteria inside the formula? And
if so, how?

Thanks,
Scott
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top