grifdoogindoggy
New Member
- Joined
- Aug 27, 2019
- Messages
- 21
I am trying to use an index function to return an array for this function:
=(INDEX(C5:F8,MATCH(H5,B5:B8,0),0))
For context, C5:F8 is a set of values for the B5:B8 set of dates. I'm trying to return a row array of elements indexed off the date.
There is no problem with my match function. I don't have a problem with the index function when I have a value for the column number.
My question is, I thought excel was supposed to return an array when the column number is 0? The excel I am working on is 2010, could this be the problem?
Thank you.
=(INDEX(C5:F8,MATCH(H5,B5:B8,0),0))
For context, C5:F8 is a set of values for the B5:B8 set of dates. I'm trying to return a row array of elements indexed off the date.
There is no problem with my match function. I don't have a problem with the index function when I have a value for the column number.
My question is, I thought excel was supposed to return an array when the column number is 0? The excel I am working on is 2010, could this be the problem?
Thank you.