combining iserror and isblank in an index match formula

[racheljallen]

I've been trying to add both iserror and isblank to my index match to give me a text value instead of being blank or an error. Here are the two i have so far that i need to try and combine.


=IFERROR(INDEX('DATA'!$A$2:$HF$291,MATCH($B10,'DATA'!$E$2:$E$291,0),MATCH(CONCATENATE($C10,"_",F$1),DATA'!$A$2:$HF$2,0)),"none")
---When the index match formula gives me a correct error message this solves my problem

--and when the data value is referencing a blank cell this formula works great:
=IF(INDEX('DATA'!$A$2:$HF$291,MATCH($B11,'DATA'!$E$2:$E$291,0),MATCH(CONCATENATE($C11,"_",F$1),'DATA'!$A$2:$HF$2,0)),ISBLANK,"no info listed")

however. i need a formula that can combine both iferror and isblank with the same text results in one formula. been working on it for 2 days and im stuck .

 

[steve the fish]

Hi see if this works:

=IFERROR(IF(INDEX(DATA!$A$2:$HF$291,MATCH($B10,DATA!$E$2:$E$291,0),MATCH(CONCATENATE($C10,"_",F$1),DATA!$A$2:$HF$2,0))="","no info listed",INDEX(DATA!$A$2:$HF$291,MATCH($B10,DATA!$E$2:$E$291,0),MATCH(CONCATENATE($C10,"_",F$1),DATA!$A$2:$HF$2,0))),"none")

 

[racheljallen]

Thank you Steve, but unfortunately that didn't work. only gave me the value none.

 

[steve the fish]

Thank you Steve, but unfortunately that didn't work. only gave me the value none.

Split out the two match formulas. The only way what I gave can only produce none all the time is that the match formulas always error. I cant tell because I cant see your sheet.

 

[racheljallen]

Wait, your formula worked. not sure what I did the first time but it worked. Thank you so much.