Posted to microsoft.public.excel.newusers

Anna

external usenet poster

Posts: 132

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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?	MIchel Khennafi	Excel Worksheet Functions	1	January 31st 07 07:11 PM
Index Function/Match Function	M Moore	Excel Discussion (Misc queries)	3	September 3rd 06 11:49 AM
Index function	Shirley	Excel Worksheet Functions	3	August 10th 06 06:51 PM
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 07:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us