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

Get live Maths 1-on-1 Classs - Class 6 to 12