daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
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[FONT=Inconsolata, monospace, arial, sans, sans-serif])
[/FONT][FONT=Inconsolata, monospace, arial, sans, sans-serif]
[/FONT]Thanks
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[FONT=Inconsolata, monospace, arial, sans, sans-serif])
[/FONT][FONT=Inconsolata, monospace, arial, sans, sans-serif]
[/FONT]Thanks