# Educate Me Please! - Index Question

#### nancybrown

##### Well-known Member
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

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
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

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?

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.

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.

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

Replies
4
Views
692
Replies
1
Views
108
Replies
24
Views
458
Replies
3
Views
239
Replies
1
Views
144

1,196,105
Messages
6,013,489
Members
441,767
Latest member
Craigh4444

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back