IFERROR INDEX MATCH not pulling data when true

cjdulk

New Member
Joined
Feb 9, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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".

Please see attached image/snip-it!

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)),"")

I cannot seem to figure out what I am doing wrong... please help!

Thanks,

Chad
 

Attachments

  • Capture654634.JPG
    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
Joined
Apr 28, 2004
Messages
76,295
Office Version
  1. 365
Platform
  1. Windows
Chad

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
Joined
Feb 9, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top