| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Database Functions
I am trying to retrieve values from a database with multiple criteria that
change from row to row. Is there any way possible to build into the formula "dynamic" criteria without having to create massive criteria tables? Back in the Lotus days you could build the criteria into the formula. DB would look like... Criteria1 Criteria2 Value A 1 $10 A 2 $15 B 1 $20 B 2 $25 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Database Functions | Excel Worksheet Functions | |||
| Database Functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Database Functions | Excel Discussion (Misc queries) | |||
| Database functions | Excel Worksheet Functions | |||
Threaded Mode
