# IFERROR INDEX MATCH not pulling data when true

#### cjdulk

##### New Member
Hello! I am having an issue with cells F5 thru F8. Cells F4 & F9 (directly before & after) are pulling the data, just fine... but F5 thru F8 are not. F5 thru F8 should be pulling the number 30.

All cells are "general".

Formula for F4: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E4,\$H\$4:\$H\$45,0)),"")
Formula for F5: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E5,\$H\$4:\$H\$45,0)),"")
Formula for F6: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E6,\$H\$4:\$H\$45,0)),"")
Formula for F7: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E7,\$H\$4:\$H\$45,0)),"")
Formula for F8: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E8,\$H\$4:\$H\$45,0)),"")
Formula for F9: =IFERROR(INDEX(\$J\$4:\$J\$45,MATCH(\$E9,\$H\$4:\$H\$45,0)),"")

Thanks,

#### Attachments

• Capture654634.JPG
135.6 KB · Views: 7

### Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

#### Norie

##### Well-known Member

Either the values in E5:E8 are numbers stored as text and the values in H36:H45 are 'real' numbers, or it's the other way about.

You can fix that by converting both ranges to either text or numbers.

#### cjdulk

##### New Member
Right now, all affected cells (in the formula) are GENERAL; I have tried changing them all to TEXT and NUMBERS - with no luck. Actually, all cells are GENERAL except for column B.

Replies
3
Views
285
Replies
0
Views
49
Replies
0
Views
88
Replies
5
Views
196
Replies
0
Views
101

1,132,640
Messages
5,654,539
Members
418,139
Latest member
nimesh72

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