Index Function Help
 

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

Index Function Help
 

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

Index Function Help
 

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



"Gary''s Student" wrote in message
...
| 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
|

Index Function Help
 

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

Index Function Help
 

Hi Niek,
Thank you, it is annoying and confusing but Im glad that this is wizard
error not mine
Regards
Anna


"Niek Otten" wrote:

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



"Gary''s Student" wrote in message
...
| 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
|