Posted to microsoft.public.excel.programming

Excelenator[_20_] Excelenator[_20_] is offline

external usenet poster

Posts: 1

INDEX functions problem

Replace the semi colons in your formula with commas.

Worksheets("Sheet1").Range("F2").Value = "INDEX(A1:E20*-,-*-4*-;-*-4)"

Nader Wrote:
Worksheets("Sheet1").Range("F2").Value = "INDEX(A1:E20;4;4)"

--
Excelenator

------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=566629

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 AND MATCHING FUNCTIONS	Jeanette	Excel Worksheet Functions	5	September 21st 09 09:23 PM
IF and INDEX functions...I'm lost...	Kim Nacrelli	Excel Discussion (Misc queries)	2	October 27th 08 02:15 PM
Row, Index, Match functions	Christopher Naveen[_2_]	Excel Discussion (Misc queries)	1	September 20th 07 08:42 AM
Index and Match Functions	Damien	Excel Worksheet Functions	4	July 29th 06 10:12 PM
How do I use the Match and Index functions to look up a value tha.	Maclanders	Excel Worksheet Functions	7	February 10th 05 08:31 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us