Hi Biff,

Try entering the following in a cell
=INDEX(A1:A5,0)

Case 1: as an array formula, and
Case 2: as a simple formula

In the first case, it returns 11 (and if you drag down, the subsequent
numbers). In the second case, it returns #VALUE and the same for
dragging down.

In you main formula, the above part is treated as an array formula and
so you get 11 in the first case, whereas in the subsequent cases
instead of 0 you get #NUM as the second argument for the index function
and so you get #NUM

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375888

Hi Biff,

your question and the solution aaray did not match. Why don't you
simply use:
=IF($A$10="X",A1,"") and copy down
or
=IF($A$10="X",A1:A5,"") as an array formula by selecting all the five
cells in the column.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375888

Thanks for your input.

Actually, I was just "playing" around with some stuff and couldn't quite
figure out what I was seeing.

Biff

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1pzm2e_1117695909.6097@excelfor um-nospam.com...

Hi Biff,

your question and the solution aaray did not match. Why don't you
simply use:
=IF($A$10="X",A1,"") and copy down
or
=IF($A$10="X",A1:A5,"") as an array formula by selecting all the five
cells in the column.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375888