MATCH gone Awry....
 

Hi
try
=MATCH(TRUE,L55:L580,0)
and enter this as array formula with CTRL+SHIFT+ENTER

--
Regards
Frank Kabel
Frankfurt, Germany

"Bill Buckner" schrieb im
Newsbeitrag ...
Here is my formula:

=MATCH(TRUE,(L55:L58)0,0)

In L55:L58 I have:

0
0
1
2

This should return 3, but it keeps returning #NA.

This used to work before I converted a few of my longer cell
calculations to VB. Now I have to hit <ctrl<alt<F9 to get my sheets
calculated.

H E L P .....