What is lookup in excel?
The Lookup function returns a value from a range or from an array. It is a predefined function in excel.Why to use lookup function?
Lookup function is used to search one column of data and find the data in the corresponding row or vice versa.
What is Vlookup and Hlookup?
Hlookup and Vlookup are functions in MS Excel that allow you to use the section of your spreadsheet as a lookup table.
Vlookup
When a Vlookup function is called, Excel searches for the lookup value in the leftmost column of a section of spreadsheet
- Vlookup works in vertical area, column wise
- Function can be called from the same sheet or from different sheet
- Can be used in variety of different ways
Hlookup
When a Hlookup function is called, Excel searches for the lookup value in the topmost row of a section of spreadsheet
- Hlookup works in Horizontal area, row wise
- Function can be called in same sheet or form different sheet
