ExcelBanter - Help with Index Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with Index Function (https://www.excelbanter.com/excel-discussion-misc-queries/186159-help-index-function.html)

Anna

Help with Index Function

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

All times are GMT +1. The time now is 02:32 PM.