You can send me the file

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"katem" wrote in message oups.com...
| Hey - just checked and both the match array and number being read in
| both are numbers. When they are in the VBA watch window, the dates
| have a # on either side and the istext function reads 'false' for
| both, so I don't think that's what's causing the issue. If you can
| tell me where I can upload, I can send the file to somewhere for
| people to look at it.
|
| I also tried it on another computer this morning and am getting the
| same results.
|
| Thanks so much for your help - any other ideas?
| Cheers,
| Kate
|
| On Jun 20, 4:16 pm, "Niek Otten" wrote:
| I suspect one of your dates (either the one to be looked up or in the table) is text and te other one(s) isn't.
| You can easily test that with the ISTEXT function..
| Just re-formatting as number or date doesn't help' you have re-format AND to re- enter (F2, ENTER) or multiply by 1 to get
nembers
| (dates).
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "katem" wrote in oglegroups.com...
|
| | Sorry - that was in my first post, should've made myself more clear.
| | The list is dates in ascending order, so I think +1 or 0 should work.
| | But neither of them are behaving.
| |
| | Any guesses?
| | Thanks for your help!
| | Kate
| |
| | On Jun 20, 12:56 pm, "Jim Cone" wrote:
| | I don't understand your answer as you don't reference the data sort order.
| |
| | If match type is -1 the data must be in descending order.
| | If match type is +1 the data must be in ascending order
| | If match type is 0 (exact match) the data can be in any order.
| | --
| | Jim Cone
| | San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
| |
| | "katem" | wrote in message
|
| | The plot thickens....
| |
| | I put in a value which was in the list to match (so an exact match
| | would work) and it brings back 0 for every value I've tried in the
| | list (whether on not it's in the list). And if I run a +1 match, I
| | always get 1026 (which is the upperbound of the array).
| |
| | I've tried it with and without the 'datevalue'.
| | Any other guesses as to what's up?
| | Thanks for your help,
| | Kate
| |
| |
|
|