VLOOKUP is definitely one of the most popular Excel functions. And this is also one of the most asked Excel questions that I have seen in interviews.

Here is the VLOOKUP syntax: 

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

• lookup_value – this is the look-up value you are trying to find in the left-most column of a table. It could be a value, a cell reference, or a text string. In the SCORE sheet EXAMPLE, this would be your name.
• table_array – this is the table array in which you are looking for the value. This could be a reference to a range of CELLS or a named range. In the score sheet example, this would be the entire table that contains score for everyone for every subject
• col_index – this is the column INDEX number from which you want to fetch the matching value. In the score sheet example, if you want the SCORES for Math (which is the first column in a table that contains the scores), you'd look in column 1. If you want the scores for Physics, you'd look in column 2.
• [range_lookup] – Here you specify whether you want an exact match or an approximate match. If omitted, it defaults to TRUE – approximate match.

If you've time, I recommend going this VLOOKUP function guide I created with 10 practical examples.

VLOOKUP is definitely one of the most popular Excel functions. And this is also one of the most asked Excel questions that I have seen in interviews.

Here is the VLOOKUP syntax: 

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

If you've time, I recommend going this VLOOKUP function guide I created with 10 practical examples.