Ok, I've searched high and low for a solution and I can't find one that works. I've tried ISNA, ISERROR and several others to no avail.

I have an IF VLOOKUP formula and I need to hide the NA errors. Unfortunately some of my co-workers aren't bright enough to understand what the error means so I need it to display "No Data Returned" instead. Here's the formula I'm currently using

=IF(0<$E5<11,VLOOKUP($A5,table_1,2),VLOOKUP($A5,table_2,2))

Any ideas?!