Posts

Showing posts from April, 2022

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

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