Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i get "DGET" to take the first data meeting the criteria?
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. |
#2
|
|||
|
|||
If you read help that is what you are supposed to get
-- Regards, Peo Sjoblom (No private emails please) "Yardarm1" wrote in message ... 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. |
#3
|
|||
|
|||
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" wrote in message ... 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. |
#4
|
|||
|
|||
"yardarm1" 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(Dat a,0,5)=y),0),3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |