Your function will work as posted. If A1 thru C6 contains:

1 2 3
4 5 6
7 8 9
10 11 12
13 14 15
16 17 18

and cells A8 thru C11 contain:

19 20 21
22 23 24
25 26 27
28 29 30

the formula correctly returns 23.

You will see an error if cell B9 contains an error.
--
Gary''s Student - gsnu200784


"anna" wrote:

Can any one can help me to solve this I dont know why I get error #value
next to Reference in the Index Function argument window
=INDEX((A1:C6,A8:C11),2,2,2) even I got the error the result comes back ok
but with one area selected there is no problem
Thanks in advance
Anna