You are here
Just like Vlookup,Hlookup is also used to compile data from different sheets to one sheet
Formula of Hlookup
=hlookup(Select item,Go to Other Sheet Select Area and Press F4,Write Row No of Area,0)
Difference between Vlookup and Hlookup
| VLOOKUP | Hlookup |
|
Full Form is Vertical Lookup |
Full Form is Horizontal Lookup |
| Item to be found is on Left | Item to be found is on Right |
| We Write Column number of Area | We Write Row number of Area |
| We drag down or copy paste downwards | We drag down or copy paste on the right |
| Vlookup searches on Right Side of the item | Vlookup searches Downwards of the item |
Assigment
