How to use VlookUp & HlookUp in Excel ?? Vlookup | Hlookup | Excel in Tamil | Excel Tamizha | Easy

How to use VlookUp & HlookUp in Excel ?? Vlookup | Hlookup | Excel in Tamil | Excel Tamizha | Easy



The VLOOKUP function, in its most basic form, says:

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range holding the value to return, return an Approximate or Exact match – specified as 1/TRUE or 0/FALSE). 


Here is Video for an Example 


Where do I begin?

In order to construct the VLOOKUP syntax, you will need four pieces of information:

1.The value to search up, also known as the lookup value.

2.The range containing the lookup value. For VLOOKUP to perform properly, the lookup value should always be in the first column in the range. For instance, if your lookup value is in column C2, your range should begin with C.

3.The number of the column in the range that includes the return value. If you provide B2:D11 as the range, for example, you should count B as the first column, C as the second, and so on.

4.You can optionally select TRUE for an approximate match and FALSE for an exact match of the return value. If nothing is specified, the default value will always be TRUE or an approximate match.



Comments

Post a Comment

Popular posts from this blog

How to use IF & IFS Formula in Excel | IF , IFS | Excel in Tamil | Excel Tamizha | VBA | BASIC |

Image
 How to use IF & IFS Formula in Excel  | IF , IFS | Excel in Tamil | Excel Tamizha | VBA | BASIC | Here i attached full explanation in Tamil The IF function is a common Excel function that allows you to perform logical comparisons between a number and what you anticipate. As a result, an IF statement can have two outcomes. If your comparison is True, the first result is True; otherwise, the second result is False. =IF(C2="Yes",1,2), for example, means IF(C2 = Yes, then return a 1, else return a 2). Note: When using text in formulae, you must surround it in quotes (e.g., "Text"). The sole exception is using TRUE or FALSE, which Excel understands automatically.
Read more

How to use Count, Counta & Count Blank in Excel ? Excel | Excel in Tamil | Excel Tamizha | VBA |

Image
 How to use Count, Counta & Count Blank in Excel ? Excel | Excel in Tamil | Excel Tamizha | VBA | The COUNT function counts the number of cells that contain numbers as well as the number of arguments in the list. To determine the number of entries in a number field that is part of a range or array of numbers, use the COUNT function. For example, to count the numbers in the range A1:A20, enter the following formula: =COUNT (A1:A20). In this example, the result is 5 if five of the cells in the range contain numbers. THE IMPACT OF SYNTAX (value1, [value2], ...) The parameters to the COUNT function are as follows: value1 is mandatory. The initial item, cell reference, or range to count numbers within. Optional: value2,... You can count numbers for up to 255 extra objects, cell references, or ranges. Description The COUNTA function counts the number of cells in a range that are not empty. COUNTA Syntax (value1, [value2], ...) The parameters to the COUNTA function are as follows: val...
Read more