Dear Noorain Pl tell me following formula - Highlight ( Example 9 - Sheet )
=*_xlfn.* IFERROR(VLOOKUP($E$10,$AF$2:$AW$40,MATCH($A$26,$AF$1:$AW$1,0)+1,0),"0") again error in E10 , E14 , E16 , E18 . seems you have linked with another sheet. you have linked with Leave_calcualtor(1).xls with Example 9.. Pl tell me how to remove.. Thanks Nikhil On Tue, Nov 15, 2011 at 8:34 AM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Thanks Don, > > I have removed all external name range link from file which were showing > ref error. > > Aside to Nikhil : In Example 9 Form's Controls has used,which are not in > excel 2003 so it is showing error. > > > -- > 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:55 AM, dguillett1 <dguille...@gmail.com> wrote: > >> That example is using an external file so the defined name shows ref >> >> Don Guillett >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Nikhil Shah <nikhil201...@gmail.com> >> *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 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 < >> noorain.ans...@gmail.com> wrote: >> >>> Dear Group, >>> >>> Please find attached Sheet to use 10 Simple way to use Indirect Function >>> example.. >>> >>> if any one have more examples Kindly share with group. >>> >>> The 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 function to convert >>> this into a reference that Excel can understand. >>> >>> The format of the function is : >>> INDIRECT( *Ref_text*, *A1* ) >>> >>> Where the arguments are as follows : >>> *Ref_text* - The text describing the reference *A1* - An optional >>> logical argument that defines the style of the *Ref_text* reference. >>> This can be either : >>> >>> - True - to denote that the reference is in A1 style >>> - False - to denote that the reference is in R1C1 style >>> >>> If this argument is omitted, it takes on the default value "True" >>> >>> -- >>> Thanks & regards, >>> Noorain Ansari >>> >>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >>> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >>> >>> -- >>> FORUM RULES (934+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (934+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------------------------------------------------------------------------------------------------------ >> To post to this group, send email to excel-macros@googlegroups.com >> > > > > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
