Posted to microsoft.public.excel.misc

Sekar

external usenet poster

Posts: 2

Indirect & addree combination

=INDIRECT("'" & A2 & "'!" & B2)
I taken this formula which is not working as in demo itself.

Any body have the usage of like combinations of Indirect & address function
in formulas

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
Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions	Mike Barlow	Excel Worksheet Functions	7	May 21st 23 07:42 PM
Combination Sum	[email protected]	Excel Worksheet Functions	4	June 27th 08 03:56 PM
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4)	Dave F[_2_]	Excel Discussion (Misc queries)	3	September 20th 07 08:36 PM
combination	combination?	Excel Discussion (Misc queries)	10	January 13th 07 04:08 AM
Indirect in combination with ROW	Nickneem	Excel Worksheet Functions	4	November 1st 05 07:19 AM

All times are GMT +1. The time now is 12:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us