Hlookup Excel Vlookup. For the table array select the portion of your table. Start writing your vlookup formula and select your vertical lookup value in this case the country brazil step 3.
Use hlookup when lookup values are located in the first row of a table. Vlookup and hlookup both are a referencing function in excel which are used to reference a data to match with a table array or a group of data and display the output the difference between these referencing functions is that vlookup uses to reference with columns while hlookup uses to reference with rows. Hlookup is a very useful function for creating horizontal lookups but as most of the tables that we deal with are vertical hence this function is not very popular.
The default is true allow non exact match.
These two functions are the lookup functions in excel that searches for the data in the table array and returns the required output. The h in the hlookup stands for horizontal and hence it is often called horizontal lookup. Use hlookup when lookup values are located in the first row of a table. Start writing your vlookup formula and select your vertical lookup value in this case the country brazil step 3.
