yardarm1 said:
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)