Can I have a IF BLANK and IF ERROR?

[natepen]

Is it possible to add both a "IFBLANK" and a "IFERROR"? I have columns that are numbered and some of those columns have blank cells that I want to say "n/a" if its blank but I also want it to say "NO SUCH STORE" if the user accidently types a wrong number thats not on my list. This is what I have so far. It works if the cell is empty and thats fine but I wanna add "IFERROR" as well.

=IF(ISBLANK(INDEX('Printable Route Groups'!A:D,MATCH(N11,'Printable PI Dates'!A:A,0),4)),"n/a",INDEX('Printable Route Groups'!A:D,MATCH(N11,'Printable PI Dates'!A:A,0),4))

Thanks
Nate

[duane]

IF(ISBLANK(INDEX('Printable Route Groups'!A:D,MATCH(N11,'Printable PI Dates'!A:A,0),4)),"n/a",if(iserror(INDEX('Printable Route Groups'!A:D,MATCH(N11,'Printable PI Dates'!A:A,0),4)),"NO SUCH STORE",INDEX('Printable Route Groups'!A:D,MATCH(N11,'Printable PI Dates'!A:A,0),4)))

I did not test though

[natepen]

Great it works! Thanks