Re: $$Excel-Macros$$ Indirect formula

Noorain Sir, I tried to understand it by example also but failed to understand.I know this is my fault but please make me understand in easy word, I can not understand in technical language. I will oblige you. Regards, Ankit On Fri, Nov 18, 2011 at 2:45 PM, NOORAIN ANSARI wrote: > Dear Ankit,

Re: $$Excel-Macros$$ Indirect formula

Hi Sumitha, Please See below links for Indirect Function More Clarification... http://www.contextures.com/xlFunctions05.html http://www.cpearson.com/excel/indirect.htm *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Tue, Nov

Re: $$Excel-Macros$$ Indirect formula

Dear Ankit, Excel INDIRECT function takes a text string and converts this into a cell reference. Excel does not understand the text string "B1" to mean a reference to the cell B1. Therefore, if you extract or build up a reference to a cell or range using text, you will need to use the INDIRECT fu

Re: $$Excel-Macros$$ Indirect formula

Hi, Plz tell me what is the use of indirect function & what it can do? Regards, Ankit On Tue, Nov 15, 2011 at 2:49 PM, NOORAIN ANSARI wrote: > Dear Smitha, > > Please find & see attached sheet with example of below formula. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworl

RE: $$Excel-Macros$$ Indirect formula

Thanks Noorain Regards Smitha From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, November 15, 2011 2:49 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Indirect formula Dear Smitha, Please find

Re: $$Excel-Macros$$ Indirect formula

Dear Smitha, Please find & see attached sheet with example of below formula. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Nov 15, 2011 at 12:

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Thanks Noorain, sorry i had missed out your response... for the first time i'm using this Indirect formula & with Adress or other criterian... will you advise me bit more about Indirect & Adress formulas usage ??with few exmples so that i can learn in detail ??? cheers JP On Fri, Nov 11, 2011

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Hello JP, In Summary B4, copy down & across. =LOOKUP(9E+300,INDIRECT("'"&$A4&"'!B1:"&ADDRESS(2^20,COLUMNS($A4:B4 __ HTH Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need

Re: $$Excel-Macros$$ Indirect Formula - Need Advise

Dear JP, Please find attached sheet, I hope it will help to u.. try.. =VLOOKUP($A2,INDIRECT($G$3&"!A:D"),MATCH(B$1,AN!$A$1:$D$1,0),0) -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

RE: $$Excel-Macros$$ Indirect Formula Help required...

Hello, You can’t use spaces in the name of named ranges, so I have replaced “Pooja Valeja” with “Pooja_Valeja” Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de lucky singh Envoyé : vendredi 10 juin 2011 13:14 À : undisclosed-recipi