# =INDEX(Y4:Y10,MATCH(M2,Z4:Z10,0))

#### trippyd

##### New Member
Hello Folks. It's been a long time since my last post as I've generally been able to find the answer. I am however now stuck and would be grateful for your help with Index/Match issue?

I have data in cells Y4:Y10 these are a money value of eg. 10, 20, 30, 40, 50, 60 & 70.
In Z4:Z10 is the Text Reference like for example = Oranges, Apples, Pears, etc.
In column "M" I have a data drop down list of my Text Reference from Z4:Z10.
In column "N" I have my value of 10, 20, 30, etc.

At point M2 and N2 the drop down list "Oranges, Apples, Pears, etc works, so I will get "(drop down in M=) Oranges (Value returned in N=) 10" - That part is correct and works. If I drag the formula down column M&N - I simply get N/A. No amount of head banging helps me get this correct.

Could / Would you help me with this please?

Dave.

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

## =INDEX(\$Y\$4:\$Y\$10,MATCH(\$M2,\$Z\$4:\$Z\$10,0))​

#### Saurabhj

##### Active Member
Hi Dave,

Make below change:

=INDEX(\$Y\$4:\$Y\$10,MATCH(M2,\$Z\$4:\$Z\$10,0))

## =INDEX(\$Y\$4:\$Y\$10,MATCH(\$M2,\$Z\$4:\$Z\$10,0))​

Thank you & the following reply for your help. Even in the videos I watched I missed the use of the "\$" - Works perfectly. Thank you MrExcel follows as usual. Dave

alz

#### trippyd

##### New Member
Hi Dave,

Make below change:

=INDEX(\$Y\$4:\$Y\$10,MATCH(M2,\$Z\$4:\$Z\$10,0))
Thank you & the following reply for your help. Even in the videos I watched I missed the use of the "\$" - Works perfectly. Thank you MrExcel follows as usual. Dave

Replies
26
Views
2K
Replies
3
Views
59
Replies
2
Views
58
Replies
7
Views
203
Replies
1
Views
127

1,132,640
Messages
5,654,535
Members
418,138
Latest member
agnesegras

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