Database function criteria

A

Art

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
 
B

Bob Phillips

Maybe

=VLOOKUP(4,calendar,2,FALSE)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
A

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
 
B

Bob Phillips

There is just the one range as there is in your Lotus example.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
A

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
 
B

Bob Phillips

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.


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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