Soldato
- Joined
- 22 Nov 2007
- Posts
- 4,176
Sorry if this is a dumb question but i’m not near my pc right now. I was chatting to
Someone laat night about index match and i was saying how i put a 0 for the final index arguement e.g.
=index(b1:b10,match(c2,’e1:e10,0),0)
I assume even though its redundant that final 0 can’t be skewint the results returned in the index formula as its only indexing one column right? Secondly, don’t column arrays start from 1 in excel? But the 0 doesn’t cause an error.
Someone laat night about index match and i was saying how i put a 0 for the final index arguement e.g.
=index(b1:b10,match(c2,’e1:e10,0),0)
I assume even though its redundant that final 0 can’t be skewint the results returned in the index formula as its only indexing one column right? Secondly, don’t column arrays start from 1 in excel? But the 0 doesn’t cause an error.