Category Excel
Home MS Office

Excel

2 Apr

Use of VLookup in Excel

Today, Let’s learn about VLookup function in Excel. Most of the people are confused in these functions. They think that this formula is hard to use. In the corporate world, VLookup formula is very useful. Usage: The VLOOKUP function can be used to find an exact match in the lookup column. Syntax: =VLOOKUP(lookup_values,table_array,row_index_num,range_lookup) Let’s understand this function with an example. I […]

READ MORE
2 Apr

Use of HLookup in Excel

Today, Let’s learn about HLookup function in Excel. Most of the people are confused in these functions. They think that this formula is hard to use. In the corporate world, HLookup formula is very useful. Usage: The HLOOKUP function can be used to find an exact match in the lookup row. Syntax =HLOOKUP(lookup_values,table_array,row_index_num,range_lookup) Let’s understand this function with […]

READ MORE