Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear CG Kumar, Step 1:- Retrive Camera from Excel Option-Customize-All Commands-add Camera in Customize access toolbar then drag it on excel sheet. Step 2:provide name range of formula * =INDIRECT("Sheet4!B"&MATCH('Indirect Example 3'!$A$4,Sheet4!$A:$A,0)) from Formula :Define Name* Step 3: Selec

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sir, Could you plz explain how did you got the pic in worksheet 3 from worksheet 4 as the function yields to 0 when pasted in other area. Regards, C.G.Kumar On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Sheet to use 10 Simple way to use Indire

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Sorry I zsee I forgot my name   Thanks, David Lanne From: David Lanne To: "excel-macros@googlegroups.com" Sent: Tuesday, November 15, 2011 1:09 AM Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function Thanks for the guide, I'

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

adlines'!$F$3,Logos!$A$:$A$,0)) My pics are in col b of Logos and the Text to match is in col A. From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Monday, November 14, 2011 10:04 PM Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Fu

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Thanks JP, Currently i m working on below mentioned formula with various live examples Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Hey Noorain, Superb Job!!! When ever you find time & who ever knows on this can help us out on : Address, Index, Match,Offset, Rows & Columns formulas the same stuff as you did now!! Cheers JP. On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached She

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

m/> > On Tue, Nov 15, 2011 at 12:55 AM, dguillett1 wrote: > >> That example is using an external file so the defined name shows ref >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Nikhil Shah >> *Sent:* Mond

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

That example is using an external file so the defined name shows ref Don Guillett SalesAid Software dguille...@gmail.com From: Nikhil Shah Sent: Monday, November 14, 2011 12:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function Dear

Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function

Dear Noorain Excellent Help. Example 9 - Sheet is showing some error...Can you rectify ? I am using Office Excel 2003. Thanks in advance Nikhil On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI wrote: > Dear Group, > > Please find attached Sheet to use 10 Simple way to use Indirect Function