1. VLOOKUP function: The VLOOKUP function is called the 'Vertical Lookup' as it executes its function for our search or certain value in a Column( Top to Bottom or visa versa). It is an inbuilt function of MS Excel that can be executed in the column by using a formula in a cell of a worksheet. This function(VLOOKUP) is available in all the version of MS office above 2000 i.e. Excel 2000, XP, Excel 2003, Excel 2007, Excel 2010, Excel 2011(MAC), Excel 2013, Excel 2016, Excel 2019 and Office 365.

The Syntax sued in VLOOKUP is : =VLOOKUP([value], [range], [column number], [false or true]), where

1. Value = It is the value you are looking for in the first column of the sheet/table.

2. Range(or table array) = It is the range/ table array in which we want to find the value and the return value.

3. Column Number(index_number) = It is the column number/index_number within your defined range, that contains the return value.

4. Match (True or False) = It is optional. You can either omit or complete your formula with this. In the formula "0 or FALSE" is used to get an exact match for the value we are looking for; or "1 or TRUE" for an approximate match. If you omit this parameter, it will show the default parameter which is True.

Ex: Find in the attachment for VLookup

2. HLOOKUP function: The HLOOKUP function is called the 'Horizontal Lookup' as it executes its function for our search or certain value in a Row( Left to Right or visa versa). It is an inbuilt function of MS Excel that can be executed in the row by using a formula in a cell of a worksheet.

The Syntax sued in HLOOKUP is : =HLOOKUP([value], [range], [row number], [false or true]), where

1. Value = It is the value you are looking for in the first row of the sheet/table.

2. Range(or table array) = It is the range/ table array in which we want to find the value and the return value.

3. Row Number(index_number) = It is the Row number/index_number within your defined range, that contains the return value. Your 1st row that contains a value is your taken as 1, the next Row as 2 and so on.

4. Match (True or False) = It is optional. You can either omit or complete your formula with this. In the formula "0 or FALSE" is used to get an exact match for the value we are looking for; or "1 or TRUE" for an approximate match. If you omit this parameter, it will show the default parameter which is True.

Ex. In the same example in the attached sheet if you have your data in horizontal format, you can use HLOOK UP formula in the same way but select your range accordingly.

*“The most important thing in life is to learn how to give out love, and to let it come in." — Morrie Schwartz*Electricity-Tariff.pdfDelete Attachment