IFERROR INDEX MATCH not pulling data when true

[cjdulk]

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

 

[Norie]

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]

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.