range_lookup – This value is optional.
![how to use vlookup in excel youtube how to use vlookup in excel youtube](https://i.ytimg.com/vi/4PWVFBiFVVU/maxresdefault.jpg)
If we wanted to retrieve the Department we would use 2, as Department is the 2nd column of the table_array). col_index_num – the column in the table from which to retrieve the value (3 in our example, as it is the 3rd column of the table_array.table_array – the range of cells which contains the data (A2 – C9 in our example).
![how to use vlookup in excel youtube how to use vlookup in excel youtube](https://i.ytimg.com/vi/BetlZJ2K1NM/maxresdefault.jpg)
lookup_value – the value to lookup in the first column (“O Reading” in our example).The Syntax of the function is: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) VLOOKUP does exactly the same thing as we would do in real life. If we wanted to find the Telephone number for ‘O Reading’ in real life we would look down column A until we found the name, then we would move across to column C (the 3rd column) to find the Telephone number. To really understand VLOOKUP it would be beneficial to use an example.
#How to use vlookup in excel youtube how to
The purpose of this post is to teach you how to use VLOOKUP. Personally, I think it is because VLOOKUP is probably the most advanced function the interviewer knows! It is certainly not the most advanced function, but you need to know it if you want to use Excel to any reasonable standard. It is used in job interviews all over the world to understand a person’s skills with Excel. You could use VLOOKUP to find the telephone number of any employee based on their name.īeing able to use VLOOKUP correctly is an Excel ability benchmark. A simple example would be a where you had a long list of employees and their telephone numbers. It allows you to look up a value from a table based on a search term.
![how to use vlookup in excel youtube how to use vlookup in excel youtube](https://i.ytimg.com/vi/qu-AK0Hv0b4/maxresdefault.jpg)
VLOOKUP is one of the most powerful functions in Excel.