Educate Me Please! - Index Question

[nancybrown]

when having an index formula such as the one below, what is the purpose of:

,0))
,0,1))

And how do I know when to use them. I keep getting different answers when running the same formula . . .

Thank you

 

[texasalynn]

when having an index formula such as the one below, what is the purpose of:

,0))
,0,1))

And how do I know when to use them. I keep getting different answers when running the same formula . . .

Thank you

I don't see your formula?

 

[nancybrown]

here is an example:

=INDEX(Template!$A$2:$A$64000,MATCH('2008&2009Terms'!D3141,Template!$C$2:$C$64000,0),1)

I understand this formula until I get to the end . . . sometimes ,0)) work and sometime it doesn't, but ,0),1) will . . . what's the difference?

 

[texasalynn]

with the last ,1 it is for the column number 1


from help
Array form

INDEX(array,row_num,column_num)

Array is a range of cells or an array constant.

If array contains only one row or column, the corresponding row_num or column_num argument is optional.

If array has more than one row and more than one column, and only row_num or column_num is used, INDEX returns an array of the entire row or column in array.

Row_num selects the row in array from which to return a value. If row_num is omitted, column_num is required.

Column_num selects the column in array from which to return a value. If column_num is omitted, row_num is required.

 

[nancybrown]

Thank you.

Confusing, but I guess I'll grasp it as I move along.

The problem I have is that some row item results are returning correctly, but others are showing as #N/A eventhough there is data to return.

 

[texasalynn]

Thank you.

Confusing, but I guess I'll grasp it as I move along.

The problem I have is that some row item results are returning correctly, but others are showing as #N/A eventhough there is data to return.

I thought so too when I was first using index/match. The #N/A usually indicates there is no match. So you may want to be sure the data is truly the same, no extra spaces behind

"A"
"A "
looks like A's match but the second one has the space behind so is not a match