Using the Vlookup function in Excel
We also have Free
training videos on this site ( visit the
Home page
or the
Training Page)
|
You can use the Vlookup function in Excel to locate a value and then insert the value in another area. If you for instance, have a register of your clients in a worksheet named “Customers” and an invoice in the worksheet called “Invoicing” and want Excel to fill in the required client name and details in the specific invoice, you will make use of the Vlookup function in Excel.
Some useful tips:
Select the range of data that contains the information that you want to pull from one worksheet. You can highlight the range in that worksheet and then rename just that range of data. Also don’t include the headings as you only want the data in the cells. |
|
You can use the Insert Function button on the toolbar and then enter the information for the following syntax areas that look like this:
VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
In the above syntax value stands for the specific value to look for in the first column of the table_array. The table_array consist of two or more columns of data. The index_num in the syntax represents the column number within the table_array from where you want the required value to be returned. You should also note that should the index_num be less than one that the function will return #Value! If the other end is true – that if the index_num is greater than the columns in your table_array then a #REF! will be returned.
You can view our free online video on using the Vlookup function in Excel or learn more about the above and other lookup features offered by the software program through our training courses to be held in South Africa.
.
|
