# Understanding a formula

#### levanoj

##### Active Member
I have a formula that appears as follows in a cell:

=index(maplabel,B3)

When I use the "Evaluate Formula" tool in Excel to see the details of the formula I see the following:

=index(MAPPER!\$C\$1:\$C\$650,B3)

What I have figured out is that the value the formula returns is found in cell D1 in a different sheet of the workbook. I know this because when I type in a different value in cell D1 of that sheet, the change is reflected in the cell where the formula is programmed

Can anyone explain in lamens terms what the above formula is doing?

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### Jonmo1

##### MrExcel MVP
1. maplabel is a named range. Found in Insert - Names - Define. It either has a direct reference to MAPPER!\$C\$1:\$C\$650, or a formula that returns that range..

2. The index formula is pretty cool. It takes these basic arguments..
=INDEX(Range,Row#,Column#).
column# is optional(if the range is only 1 column wide)

so it goes to that range, and returns the value in the corresponding Row# and Column #.

Example
=INDEX(A1:E10,4,3)
Would return the value in C4 (4th Row, 3rd Column)

=index(maplabel,B3)

It first takes the named range maplabel and converts it to the actual range
MAPPER!\$C\$1:\$C\$650

so it's now
=index(MAPPER!\$C\$1:\$C\$650,B3)

Then it's taking the value of B3(a number say 10 for example) and returning the value from MAPPER!\$C\$1:\$C\$650 that is in the 10th Row (C10).

Hope that helps..

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,147
Messages
5,835,673
Members
430,374
Latest member
PeteBrown

### 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