Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
Dear Kumar, There are lot of tutorial / training documents. Just google it. Regards, Ganesh N On Wed, Oct 8, 2014 at 3:21 PM, Kumar Kishore wrote: > Dear Sir, > > Thank you for your kind co-operation and feedback and response. > > But i don't know Basics. > > Kindly advice us. > > Regards, > > Deva Rayudu > > On Tue, Oct 7, 2014 at 6:42 PM, Paul Schreiner > wrote: > >> That's what we're here for... (helping) >> But it's also guidance for "selp help". >> >> If we can show you where to FIND what you're looking for, you don't have >> to wait for one of us to respond! >> >> Plus, often when you're looking for a solution to the problem in front of >> you, >> you come across answers to questions you haven't even asked (yet)! >> >> let us know if you have trouble, or need an explanation as to how (or >> why) something works. >> >> *Paul* >> - >> >> >> >> >> >> >> >> *“Do all the good you can,By all the means you can,In all the ways you >> can,In all the places you can,At all the times you can,To all the people >> you can,As long as ever you can.” - John Wesley* >> - >> >>*From:* Kumar Kishore >> *To:* excel-macros@googlegroups.com >> *Sent:* Tuesday, October 7, 2014 5:23 AM >> *Subject:* Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS >> >> Dear Sirs, >> >> Thank you so much. >> >> I Will learn from you. from today onwards. >> >> Regards, >> Kishore. >> >> >> >> On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner >> wrote: >> >> I can probably handle explaining Vlookup and Hlookup, >> but to teach "macros"??? >> >> That's what this group is for! >> The techniques of using macros is a subject about which many books have >> been written >> and thousands (and thousands) of emails have been shared. >> >> There's really no single way to "teach macros". >> The first step is to have a PURPOSE. >> A task you want to accomplish. >> Usually, some repetative or tedious task you wish to automate. >> >> Then, you proceed to write VBA code to perform this task. >> (often by turning on the macro recorder while you perform some tasks >> manually) >> >> As for VLookup and HLookup: >> >> The fact that you turned to a group such as this, with such a general >> question is concerning. >> >> Have you ever used the Function Wizard? >> The "Help on this function" link at the bottom of the Insert Function >> panel is actually very helpful. >> >> for VLOOKUP, you get: >> Syntax >> >> VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) >> >> The VLOOKUP function syntax has the following arguments (argument: A >> value that provides information to an action, an event, a method, a >> property, a function, or a procedure.): >> >>- *lookup_value* Required. The value to search in the first column of >>the table or range. The *lookup_value* argument can be a value or a >>reference. If the value you supply for the l*ookup_value* argument is >>smaller than the smallest value in the first column of the >>*table_array* argument, *VLOOKUP* returns the #N/A error value. >>- *table_array* Required. The range of cells that contains the data. >>You can use a reference to a range (for example, *A2:D8*), or a range >>name. The values in the first column of *table_array* are the values >>searched by *lookup_value*. These values can be text, numbers, or >>logical values. Uppercase and lowercase text are equivalent. >>- *col_index_num* Required. The column number in the *table_array* >>argument from which the matching value must be returned. A >>*col_index_num* argument of 1 returns the value in the first column >>in *table_array*; a *col_index_num* of 2 returns the value in the >>second column in *table_array*, and so on. >> >> If the *col_index_num* argument is: >> >>- Less than 1, *VLOOKUP* returns the #VALUE! error value. >>- Greater than the number of columns in *table_array*, *VLOOKUP* >>returns the #REF! error value. >> >> >>- *range_lookup* Optional. A logical value that specifies whether you >>want *VLOOKUP* to find an exact match or an approximate match: >> >> >>- If *range_lookup* is eit
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
Dear Sir, Thank you for your kind co-operation and feedback and response. But i don't know Basics. Kindly advice us. Regards, Deva Rayudu On Tue, Oct 7, 2014 at 6:42 PM, Paul Schreiner wrote: > That's what we're here for... (helping) > But it's also guidance for "selp help". > > If we can show you where to FIND what you're looking for, you don't have > to wait for one of us to respond! > > Plus, often when you're looking for a solution to the problem in front of > you, > you come across answers to questions you haven't even asked (yet)! > > let us know if you have trouble, or need an explanation as to how (or why) > something works. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > >*From:* Kumar Kishore > *To:* excel-macros@googlegroups.com > *Sent:* Tuesday, October 7, 2014 5:23 AM > *Subject:* Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > Dear Sirs, > > Thank you so much. > > I Will learn from you. from today onwards. > > Regards, > Kishore. > > > > On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner > wrote: > > I can probably handle explaining Vlookup and Hlookup, > but to teach "macros"??? > > That's what this group is for! > The techniques of using macros is a subject about which many books have > been written > and thousands (and thousands) of emails have been shared. > > There's really no single way to "teach macros". > The first step is to have a PURPOSE. > A task you want to accomplish. > Usually, some repetative or tedious task you wish to automate. > > Then, you proceed to write VBA code to perform this task. > (often by turning on the macro recorder while you perform some tasks > manually) > > As for VLookup and HLookup: > > The fact that you turned to a group such as this, with such a general > question is concerning. > > Have you ever used the Function Wizard? > The "Help on this function" link at the bottom of the Insert Function > panel is actually very helpful. > > for VLOOKUP, you get: > Syntax > > VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) > > The VLOOKUP function syntax has the following arguments (argument: A > value that provides information to an action, an event, a method, a > property, a function, or a procedure.): > >- *lookup_value* Required. The value to search in the first column of >the table or range. The *lookup_value* argument can be a value or a >reference. If the value you supply for the l*ookup_value* argument is >smaller than the smallest value in the first column of the >*table_array* argument, *VLOOKUP* returns the #N/A error value. >- *table_array* Required. The range of cells that contains the data. >You can use a reference to a range (for example, *A2:D8*), or a range >name. The values in the first column of *table_array* are the values >searched by *lookup_value*. These values can be text, numbers, or >logical values. Uppercase and lowercase text are equivalent. >- *col_index_num* Required. The column number in the *table_array* >argument from which the matching value must be returned. A >*col_index_num* argument of 1 returns the value in the first column in >*table_array*; a *col_index_num* of 2 returns the value in the second >column in *table_array*, and so on. > > If the *col_index_num* argument is: > >- Less than 1, *VLOOKUP* returns the #VALUE! error value. >- Greater than the number of columns in *table_array*, *VLOOKUP* >returns the #REF! error value. > > >- *range_lookup* Optional. A logical value that specifies whether you >want *VLOOKUP* to find an exact match or an approximate match: > > >- If *range_lookup* is either TRUE or is omitted, an exact or >approximate match is returned. If an exact match is not found, the next >largest value that is less than *lookup_value* is returned. > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Kumar Kishore > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, October 5, 201
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
That's what we're here for... (helping) But it's also guidance for "selp help". If we can show you where to FIND what you're looking for, you don't have to wait for one of us to respond! Plus, often when you're looking for a solution to the problem in front of you, you come across answers to questions you haven't even asked (yet)! let us know if you have trouble, or need an explanation as to how (or why) something works. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - > > From: Kumar Kishore >To: excel-macros@googlegroups.com >Sent: Tuesday, October 7, 2014 5:23 AM >Subject: Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > > >Dear Sirs, > >Thank you so much. > >I Will learn from you. from today onwards. > >Regards, >Kishore. > > > > > > >On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner wrote: > >I can probably handle explaining Vlookup and Hlookup, >>but to teach "macros"??? >> >>That's what this group is for! >>The techniques of using macros is a subject about which many books have been >>written >>and thousands (and thousands) of emails have been shared. >> >>There's really no single way to "teach macros". >>The first step is to have a PURPOSE. >>A task you want to accomplish. >>Usually, some repetative or tedious task you wish to automate. >> >>Then, you proceed to write VBA code to perform this task. >>(often by turning on the macro recorder while you perform some tasks manually) >> >>As for VLookup and HLookup: >> >>The fact that you turned to a group such as this, with such a general >>question is concerning. >> >>Have you ever used the Function Wizard? >>The "Help on this function" link at the bottom of the Insert Function panel >>is actually very helpful. >> >>for VLOOKUP, you get: >>Syntax >>VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) >>The VLOOKUP function syntax has the following arguments(argument: A value >>that provides information to an action, an event, a method, a property, a >>function, or a procedure.): >> * lookup_value Required. The value to search in the first column of the >> table or range. The lookup_value argument can be a value or a reference. If >> the value you supply for the lookup_value argument is smaller than the >> smallest value in the first column of the table_array argument, VLOOKUP >> returns the #N/A error value. >> * table_array Required. The range of cells that contains the data. You >> can use a reference to a range (for example, A2:D8), or a range name. The >> values in the first column of table_array are the values searched by >> lookup_value. These values can be text, numbers, or logical values. >> Uppercase and lowercase text are equivalent. >> * col_index_num Required. The column number in the table_array argument >> from which the matching value must be returned. A col_index_num argument of >> 1 returns the value in the first column in table_array; a col_index_num of 2 >> returns the value in the second column in table_array, and so on. >>If the col_index_num argument is: >> * Less than 1, VLOOKUP returns the #VALUE! error value. >> * Greater than the number of columns in table_array, VLOOKUP returns >> the #REF! error value. >> * range_lookup Optional. A logical value that specifies whether you >> want VLOOKUP to find an exact match or an approximate match: >> * If range_lookup is either TRUE or is omitted, an exact or approximate >> match is returned. If an exact match is not found, the next largest value >> that is less than lookup_value is returned. >> >>Paul >>- >>“Do all the good you can, >>By all the means you can, >>In all the ways you can, >>In all the places you can, >>At all the times you can, >>To all the people you can, >>As long as ever you can.” - John Wesley >>- >> >> >> From: Kumar Kishore >>>To: excel-macros@googlegroups.com >>>Sent: Sunday, October 5, 2014 6:13 AM >>>Subject: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS >>> >>> >>> >>>Dear Masters, >>> >>>Ple
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
Dear Sirs, Thank you so much. I Will learn from you. from today onwards. Regards, Kishore. On Mon, Oct 6, 2014 at 5:23 PM, Paul Schreiner wrote: > I can probably handle explaining Vlookup and Hlookup, > but to teach "macros"??? > > That's what this group is for! > The techniques of using macros is a subject about which many books have > been written > and thousands (and thousands) of emails have been shared. > > There's really no single way to "teach macros". > The first step is to have a PURPOSE. > A task you want to accomplish. > Usually, some repetative or tedious task you wish to automate. > > Then, you proceed to write VBA code to perform this task. > (often by turning on the macro recorder while you perform some tasks > manually) > > As for VLookup and HLookup: > > The fact that you turned to a group such as this, with such a general > question is concerning. > > Have you ever used the Function Wizard? > The "Help on this function" link at the bottom of the Insert Function > panel is actually very helpful. > > for VLOOKUP, you get: > Syntax > > VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) > > The VLOOKUP function syntax has the following arguments (argument: A > value that provides information to an action, an event, a method, a > property, a function, or a procedure.): > >- *lookup_value* Required. The value to search in the first column of >the table or range. The *lookup_value* argument can be a value or a >reference. If the value you supply for the l*ookup_value* argument is >smaller than the smallest value in the first column of the >*table_array* argument, *VLOOKUP* returns the #N/A error value. >- *table_array* Required. The range of cells that contains the data. >You can use a reference to a range (for example, *A2:D8*), or a range >name. The values in the first column of *table_array* are the values >searched by *lookup_value*. These values can be text, numbers, or >logical values. Uppercase and lowercase text are equivalent. >- *col_index_num* Required. The column number in the *table_array* >argument from which the matching value must be returned. A >*col_index_num* argument of 1 returns the value in the first column in >*table_array*; a *col_index_num* of 2 returns the value in the second >column in *table_array*, and so on. > > If the *col_index_num* argument is: > >- Less than 1, *VLOOKUP* returns the #VALUE! error value. >- Greater than the number of columns in *table_array*, *VLOOKUP* >returns the #REF! error value. > > >- *range_lookup* Optional. A logical value that specifies whether you >want *VLOOKUP* to find an exact match or an approximate match: > - If *range_lookup* is either TRUE or is omitted, an exact or > approximate match is returned. If an exact match is not found, the next > largest value that is less than *lookup_value* is returned. > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* Kumar Kishore > *To:* excel-macros@googlegroups.com > *Sent:* Sunday, October 5, 2014 6:13 AM > *Subject:* $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > Dear Masters, > > Please teach the following functions:- > > 1. VLOOKUP > 2. HLOOKUP and > 3. MACROS > > > Thank in advance > > > Regards, > > Kishore > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > > >-- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook p
Re: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS
I can probably handle explaining Vlookup and Hlookup, but to teach "macros"??? That's what this group is for! The techniques of using macros is a subject about which many books have been written and thousands (and thousands) of emails have been shared. There's really no single way to "teach macros". The first step is to have a PURPOSE. A task you want to accomplish. Usually, some repetative or tedious task you wish to automate. Then, you proceed to write VBA code to perform this task. (often by turning on the macro recorder while you perform some tasks manually) As for VLookup and HLookup: The fact that you turned to a group such as this, with such a general question is concerning. Have you ever used the Function Wizard? The "Help on this function" link at the bottom of the Insert Function panel is actually very helpful. for VLOOKUP, you get: Syntax VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) The VLOOKUP function syntax has the following arguments(argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.): * lookup_value Required. The value to search in the first column of the table or range. The lookup_value argument can be a value or a reference. If the value you supply for the lookup_value argument is smaller than the smallest value in the first column of the table_array argument, VLOOKUP returns the #N/A error value. * table_array Required. The range of cells that contains the data. You can use a reference to a range (for example, A2:D8), or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase text are equivalent. * col_index_num Required. The column number in the table_array argument from which the matching value must be returned. A col_index_num argument of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If the col_index_num argument is: * Less than 1, VLOOKUP returns the #VALUE! error value. * Greater than the number of columns in table_array, VLOOKUP returns the #REF! error value. * range_lookup Optional. A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match: * If range_lookup is either TRUE or is omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Kumar Kishore >To: excel-macros@googlegroups.com >Sent: Sunday, October 5, 2014 6:13 AM >Subject: $$Excel-Macros$$ VLOOKUP AND HLOOKUP and MACROS > > > >Dear Masters, > >Please teach the following functions:- > >1. VLOOKUP >2. HLOOKUP and >3. MACROS > > > >Thank in advance > > > >Regards, > > >Kishore > -- >Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >https://www.facebook.com/discussexcel > >FORUM RULES > >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) Jobs posting is not allowed. >6) Sharing copyrighted material and their links is not allowed. > >NOTE : Don't ever post confidential data in a workbook. Forum owners and >members are not responsible for any loss. >--- >You received this message because you are subscribed to the Google Groups "MS >EXCEL AND VBA MACROS" group. >To unsubscribe from this group and stop receiving emails from it, send an >email to excel-macros+unsubscr...@googlegroups.com. >To post to this group, send email to excel-macros@googlegroups.com. >Visit this group at http://groups.google.com/group/excel-macros. >For more options, visit https://groups.google.com/d/optout. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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 rega
