Posted to microsoft.public.excel.misc

Luke

Posts: n/a

Index formula help

I am trying to link the named range section of my index formula to a drop
down list. e.g. instead of INDEX(W5e01,3,1) I am trying to link to a cell
containing 'w5e01' such as INDEX(A1,3,1). The reason for this being so I can
change the named range.

However it does not appear to be working. Any ideas?

Thanks

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
how to write the formula using INDEX?	gipsassignment	Excel Discussion (Misc queries)	2	October 2nd 05 12:30 PM
index match formula	andrewm	Excel Worksheet Functions	3	July 22nd 05 08:36 AM
Sum and Index formula?	Luke	Excel Discussion (Misc queries)	2	April 6th 05 12:58 PM
Match / Vlookup within an Array formula	Hari Prasadh	Excel Discussion (Misc queries)	3	February 3rd 05 04:37 PM
Min formula not returning value from Index	ExcelMonkey	Excel Worksheet Functions	3	January 29th 05 01:47 AM

All times are GMT +1. The time now is 06:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us