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

"Bob Phillips" wrote:

Maybe

=VLOOKUP(4,calendar,2,FALSE)

--
---
HTH

Bob


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



"Art" wrote in message
...
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