Excel: Error with formula


I am getting an #NA error with this formula? It has worked forever, why all of the sudden would it not be working? =IF(B20<>"",INDEX(B19:B51,MATCH(TRUE,INDEX(NOT(ISNUMBER(B19:B51)),),FALSE)-1),B19) Thanks


This question generated 31 answers. To proceed to the answers, click here.

This thread is current as of January 04, 2014.


For more resources for Microsoft Excel