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