Good morning,
I've asked twice prior to today and received no response, if it can't be
done or no one can figure it out, please just let me know so I can stop going
crazy :)

When $N$16:$N$25 in the formula below contains blanks, it returns #NA How
can i modify this formula to ignore blanks?

{=INDEX([NEAST2_1.XLW]Sheet1!$A$16:$A$25,
IF(ISERROR(MATCH(-MIN(ABS([NEAST2_1.XLW]Sheet1!$N$16:$N$25)),
[NEAST2_1.XLW]Sheet1!$N$16:$N$25,
0)),MATCH(MIN(ABS([NEAST2_1.XLW]Sheet1!$N$16:$N$25)),
[NEAST2_1.XLW]Sheet1!$N$16:$N$25,
0),MATCH(-MIN(ABS([NEAST2_1.XLW]Sheet1!$N$16:$N$25)),
[NEAST2_1.XLW]Sheet1!$N$16:$N$25, 0)))}

The formula is finding the # closest to 0 (returning negatives first) should
0 not
exist and retunring the corresponding rate in column A.

Entering a number into the blank fields is not an option as I have 20 sheets
with many tables.

Thank you in advance for your help!
Jeze