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
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 http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Tue, Nov
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
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 noorain.ans...@gmail.comwrote:
Dear Smitha,
Please find see attached sheet with example of below formula.
--
Thanks regards,
Noorain Ansari
Dear Smitha,
Please find see attached sheet with example of below formula.
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:13
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
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
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://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*
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
À :