

Vlookup And Hlookup in Excel 

Home  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010  
About Us  Free Ebook  Offline Training  Blog  Books on Vlookup  

Let's first use Hlookup to find out how many "Bolts" we sold in August. Then let us use Vlookup to find out again how many "Bolts" we sold in August. The result should of course be the same. There is no hard and fast rule when to use which function. It depends on how comfortable you are with the lookup functions. Many people prefer to use Vlookup. But as you saw you can also us Hlookup! In Vlookup you define the first the item in column 1 and lookup the value in another column as shown in the example above. The data need not be sorted and for the [range_lookup] parameter you write "FALSE". If you enter "TRUE" or omit the value for the [range_lookup], your data needs to be sorted in 'ascending' order or you might receive 'strange' results. In Hlookup you define the item in the first row and lookup a value in the other rows in the same column. The topmost row has the row_index value of 1. Here gain you need to use [range_lookup] parameter as "FALSe" if your data is not sorted which will be the case in most practical situations. In case you omit the parameter [range_lookup] or use "TRUE" you have to sort the data in ascending order to extract the correct information. The table_array parameter is your complete data including the headers. To make things simpler and not to have to select all the necessary cells, it is better to select the range and assign it a name like mydata. So now instead of selecting the complete data everytime you perform a Vlookup or Hlookup, you just write the name mydata. The Excel training video demonstrates the whole idea. 



Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010  
About Us  Free Ebook  Offline Training  Blog 
Books on Vlookup 