Then we have to enter the details as shown in the picture. We get a new function window showing in the below mention pictures. VLOOKUP lookup_value table_array col_index_num range_lookup As you see the function has 4 arguments - the first three are requited and the last one is optional.
In the parenthesis enter the set of Arguments for the above instance.
It goes from top to bottom and finds the value in cell A6. Click on formula tab lookup reference click on vlookup. How to Use VLOOKUP with Multiple Criteria. VLOOKUP Formula VLOOKUP lookup_value table_array col_index_num range_lookup To translate this to simple English the formula is saying Look for this piece of information in the following area and give me some corresponding data from another column.