Posted to microsoft.public.excel.misc

external usenet poster

Posts: 132

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDEX FUNCTION	Gulfman100	New Users to Excel	6	April 11th 08 12:51 PM
Index Function	SJT	Excel Discussion (Misc queries)	3	November 9th 06 02:54 AM
Index Function/Match Function	M Moore	Excel Discussion (Misc queries)	3	September 3rd 06 11:49 AM
If function using Index	dbl	Excel Worksheet Functions	13	August 9th 05 06:35 PM
Emulate Index/Match combo function w/ VBA custom function	Spencer Hutton	Excel Worksheet Functions	2	May 2nd 05 05:26 PM

All times are GMT +1. The time now is 04:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us