how do i get "DGET" to take the first data meeting the criteria?

[Yardarm1]

There is more than one record in my array that matches the criteria. I would
like to use the first accurance.
At present time I am getting an error message.

[Peo Sjoblom]

If you read help that is what you are supposed to get

--
Regards,

Peo Sjoblom

(No private emails please)


"Yardarm1" <Yardarm1@discussions.microsoft.com> wrote in message
news:2044DB69-EFDF-4B98-9118-18C2FFB55C28@microsoft.com...
> There is more than one record in my array that matches the criteria. I
> would
> like to use the first accurance.
> At present time I am getting an error message.

[yardarm1]

i know that is what you are suposed to get. What I am looking for is an if
statement using the error code to jump around the error statement and use the
first accurance of a match.

"Peo Sjoblom" wrote:

> If you read help that is what you are supposed to get
>
> --
> Regards,
>
> Peo Sjoblom
>
> (No private emails please)
>
>
> "Yardarm1" <Yardarm1@discussions.microsoft.com> wrote in message
> news:2044DB69-EFDF-4B98-9118-18C2FFB55C28@microsoft.com...
> > There is more than one record in my array that matches the criteria. I
> > would
> > like to use the first accurance.
> > At present time I am getting an error message.
>
>

[Harlan Grove]

"yardarm1" <yardarm1@discussions.microsoft.com> wrote...
>i know that is what you are suposed to get. What I am looking for is an if
>statement using the error code to jump around the error statement and use
the >first accurance of a match.
....

You can't use DGET for this. DGET will *ALWAYS* return errors when there are
multiple matches. It *ONLY* works when there's one and only one match.

You could use INDEX and MATCH in an array formula. You'd need to translate
your DGET criteria to a formula expression. Something like

=INDEX(Data,MATCH(1,(INDEX(Data,0,2)=x)*(INDEX(Data,0,5)=y),0),3)