Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I am using =index,match,match to extract data from an array which I don't control. It worked fine whilst the entries in the left-most column were sorted (descending) but with new lines being added by other users, the formula is now returning garbage. I've tried a number of methods but nothing that doesn't involve numerous steps seems to work consistently. Any idea sout there? -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=470386 |
#2
![]() |
|||
|
|||
![]()
check the third argument of the match function. i assume you want to match
your data exactly - it should be set to 0. the match function can match data exactly or approximately, but it is determined by the third argument of the function. if you want to match data approximately, your list will need to be sorted. "Brisbane Rob" wrote: I am using =index,match,match to extract data from an array which I don't control. It worked fine whilst the entries in the left-most column were sorted (descending) but with new lines being added by other users, the formula is now returning garbage. I've tried a number of methods but nothing that doesn't involve numerous steps seems to work consistently. Any idea sout there? -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=470386 |
#3
![]() |
|||
|
|||
![]()
If your data is not sorted, I would guess that you want an exact match.
Did your =match() expressions look like: =match(a1,sheet2!a:a,0) (that last 0 says exact match) Debra Dalgleish has lots of tips at: http://www.contextures.com/xlFunctions03.html Brisbane Rob wrote: I am using =index,match,match to extract data from an array which I don't control. It worked fine whilst the entries in the left-most column were sorted (descending) but with new lines being added by other users, the formula is now returning garbage. I've tried a number of methods but nothing that doesn't involve numerous steps seems to work consistently. Any idea sout there? -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=470386 -- Dave Peterson |
#4
![]() |
|||
|
|||
![]() Thanks - I didn't know about the 0 -- Brisbane Rob ------------------------------------------------------------------------ Brisbane Rob's Profile: http://www.excelforum.com/member.php...o&userid=25096 View this thread: http://www.excelforum.com/showthread...hreadid=470386 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Print sorted data | Excel Discussion (Misc queries) | |||
Lookup thinks data isn't sorted | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |