HLOOKUP is a function that looks for a value in the top rows of a table or array and returns the value in the same column from a row you specify. It is nothing but another function for looking up …
Lesson#11: How to use the HLOOKUP function in Excel? Read more »
In this post, we will learn a very useful function VLOOKUP (Vertical Lookup, or value lookup in columns) by which we can easily find data within a table. I have made Data Validation (List) within a cell which shows the …
In this post, we will learn the function DATA VALIDATION. This is very useful for making a proper data entry. I will give a good example of where we can use it. I made a report card format in another …