The result is correct, but the point is the error in the Function wizard dialog.
It's the same in Excel2007.
There are more situations where the function wizard doesn't mimic the behavior of the functions exactly, like with number
arguments being text, etc.
Maybe we should report this to MSFT so it can be corrected in some future version. After all, it's not *very* important but it
*is* confusing. And the wizard is likely to be used by people who are not very confident (of course I'm not talking about you,
Anna!)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| 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 don't 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
| >
