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 <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 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 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.
