Hi Gary,
Thank you for your respond but the thing is the formula did work correctly
before there is no error in cell B9 and there is no problem and no error when
I type the function directly into the cell but the error #value comes in the
Function wizard dialog when I put the two areas in brackets separated by coma
Regards Anna

"Gary''s Student" wrote:

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