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 schreiner_p...@att.net 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 kishore...@gmail.com *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 schreiner_p...@att.net 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 kishore...@gmail.com *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
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 kishore...@gmail.com 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 schreiner_p...@att.net 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 kishore...@gmail.com *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 schreiner_p...@att.net 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 kishore...@gmail.com *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 @
