HLookup in Excel

How to use HLookup in Excel? The Letter “H” in HLOOKUP in excel stands for Horizontal Lookup. It is an in-built function in Microsoft Excel that allows you to search a specified value in the first or top row of a table (dataset) and retrieve a value in the same …

Read more

VLookup in Excel

Function – VLookup in Excel Vlookup in excel is a very useful in-built function in Microsoft Excel. VLOOKUP stand for Vertical Lookup and it allows you to search a specified value in the first/Leftmost column of a table vertically and retrieve a value in the same row from another column on the right side.  …

Read more

Index