Both LOOKUP functions can be used to help you find specific data located in a database or list of data. The difference between the two functions lies in how your data is organized.
If the data is organized in columns, you would use VLOOKUP. If the data is kept in rows, you would use HLOOKUP.
To find out all the details read the step by step tutorial on How to Use HLOOKUP in Excel .