Bob
Fri May 09 14:24:40 CDT 2008
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)
"Art" <Art@discussions.microsoft.com> wrote in message
news:E48198F1-4C7D-4C7B-A108-30107306B2A3@microsoft.com...
> 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
>
> "Bob Phillips" wrote:
>
>> 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)
>>
>>
>>
>> "Art" <Art@discussions.microsoft.com> wrote in message
>> news:035BD547-09B6-4B39-AA75-6167B8E03611@microsoft.com...
>> > 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" <Art@discussions.microsoft.com> wrote in message
>> >> news:4229086F-C5FD-40F2-9C12-67118C9198CD@microsoft.com...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>