Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database function criteria
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 -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=558659 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function using Criteria on different worksheet | Excel Discussion (Misc queries) | |||
can countif function look at 2 separate columns for criteria | Excel Worksheet Functions | |||
Excel COUNTIF Function - a range as criteria ? | Excel Worksheet Functions | |||
How can I reference a cell as the criteria in a count if function. | Excel Discussion (Misc queries) | |||
SUMIF function - criteria of between two dates. How? | Excel Worksheet Functions |