 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008Database function criteria
In Lotus 1-2-3, you are no longer tied to a criteria range. You can embed a formula in the criteria field. For example, if I have a database named Calendar with columns titled: Number Name Weeks I can create a function like =DGET(calendar,"name",number=4). This eliminates the necessity of creating criteria ranges. Is such a thing possible in Excel? Art Maybe =VLOOKUP(4,calendar,2,FALSE)  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > In Lotus 1-2-3, you are no longer tied to a criteria range. You can embed > a [quoted text clipped - 8 lines] > > Art That will probably work in this example, but doesn't resolve the basic question of: are we stuck using criteria ranges in Excel? Is there some way to emulate the much simpler approach of 1-2-3? Art > Maybe > [quoted text clipped - 12 lines] > > > > Art There is just the one range as there is in your Lotus example. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > That will probably work in this example, but doesn't resolve the basic > question of: are we stuck using criteria ranges in Excel? Is there some [quoted text clipped - 20 lines] >> > >> > Art Bob: I think you are missing my point. You will notice in my DGET example that I do not refer to a "criteria range". I instead have inserted the formula "number=1". This eliminates the necessity of creating a "criteria range" and then referring to it in the DGET formula. The criteria is defined in the DGET formula itself. This is a much simpler method of handling the criteria. Art > There is just the one range as there is in your Lotus example. > [quoted text clipped - 22 lines] > >> > > >> > Art I don't see what the difference is. Number = is just an explicit argument as far as I can see. The 4 in the VLOOKUP is an argument, there is no criteria range, you are passing the parameter value directly. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Bob: > [quoted text clipped - 38 lines] >> >> > >> >> > Art |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.